1.1.7: Data API builder for Azure Databases

What's Changed

New Features

• Multiple db support for REST scenario #2169
• .NET 8 multi-targetting #2181
• GraphQL Multiple Create for MSSQL #2122
  • Request Validation #2057
  • Order determination for create mutations #2056
  • Database query generation and GraphQL selection set resolution #1994
• Pagination limits with config properties default-page-size and max-page-size #2153
• Root / endpoint returns DAB Version/App User Agent #2086
• PostgreSQL: Supplement application name in connection string #2208
• Cosmos DB: Patch Support (via new patchEntity mutation) #2161
• Cosmos DB: Item Level AuthZ enabled by database policies #2106
• Cosmos DB: Adding In-Memory cache support #2015

New Config Validation

• Validation for relationship defined fields #2139
  • {source/target}
  • {source/linking-source}
  • {target/linking-target}
• CosmosDB circular reference validation for entities in GraphQL schema #2192
• Validation against unsupported scenario: multiple create on related entities backed by same database table #2189

Bug Fixes

• dab validate now properly resolves environment variables in dab-config.json #2215

• dab validate Returns proper error message when validations can't proceed due to invalid/no connection string. #2202

• dab validate Relationships must define source/target/linking fields using table column names (not field aliases) #2175

• dab validate Fix dataSourceName not found exception #2040

• dab validate Fix error fetching schema from URL error emitted #2099

• GraphQL - Entities with self-joining relationships get expected query responses #2138

• GraphQL - Coerce integer values to float/decimal for float/decimal fields in GraphQL requests #2205

• GraphQL - Ensure endCursor is NULL when hasNextPage is FALSE in response #2121

• Cosmos DB: Emit user-readable error message when user provided GraphQL schema (schema.gql) references an entity not defined in dab-config.json #2186

• Cosmos DB: DAB no longer emits an OpenAPI init error message in the console when DAB is configured to use CosmosDB #2072

• DAB CLI - Returns appropriate exit code based upon exit reason #2084

• DAB CLI - dab start --help loglevel link is now user-readable #2083

• Container App Deployment - Upgraded containerApp API version so deployments no longer throw WorkloadProfilePropertyNotSupportedInApiVersion #2114

• Relationship Config Processing - No longer hangs nor throws unhandled exception when a table definition is not found in the database #2100

• Fix Performance Issue for filtering on varchar columns in MS_SQL database #2052

• Updating order of variable evaluation in Multiple create order helper #2195

• Ensure environment variables works for child files #2201

• Correctly resolve uniqueidentifier database type from dab-config.json defined stored proc parameter default values instead of erroring out. #2042

• DAB correctly handles tables with the same name, in different schemas #1990

• No longer adds redundant join condition to some t-sql queries generated when traversing a relationship in GraphQL #2051

Engineering Maintenance

• Update Npgsql to 7.0.7 for .NET6 #2214
• Update Npgsql to 8.0.3 for .NET8 #2207
• Set DAB version to 1.1 in directory.build.props #2209
• GitHub Codespaces support for Pull Request review (.NET6 SDK included in image) #2149

Documentation

• Updates support.md page #2216

See More (non-user facing changes)

MSSQL Engineering Fundamentals

• Perform recursive authz and request validation only when multiple-create is enabled #2199
• DatabaseObject Serialization now simplifies value of type name #2154
• Update notice-generation.ps1 to reference latest dependency versions #2151
• Maintain Default Data Source Name from Original Config after Hot Reloading #2069
• Only instantiate the file watcher in a hot reloadable scenario #2108

DW

• Introduce new metadata provider initialize method #2101
• Multi-DB: Making datasourcename mandatory during executequeryasync #2112
• executionHelper access modifer set to public #2102
• Stored proc support test cases REST DW. #2048
• Fixing nit comments from previous DW mutation support prs. #2043

CosmosDB - Engineering Fundamentals

• Cosmos DB: refactoring tests queries #2060
• Cosmos DB: Added Authorization related tests #2034
• Cosmos DB: Upgrade Cosmos DB SDK to latest version i.e. 3.38.1 #2073

1.1.3-rc: Data API builder for Azure Databases

What's Changed

Enhancement

• Add application name for PGSQL connections #2208
• Update Npgsql to 7.0.7 for net6 in #2214

Bug Fixees

• Fix dab validate handling of environment variables in config in #2215

Engineering Maintenance

• Add application name for PGSQL connections #2208

Documentation

• Updates support document #2216

Full Changelog: v1.1.2-rc...v1.1.3-rc

1.1.2-rc: Data API builder for Azure Databases

What's Changed

New Features

• Multiple db support for REST scenario by @rohkhann in #2169
• .NET 8 Upgrade (Multi Framework targetting) by @seantleonard in #2181

Bug Fixes

• Updating order of variable evaluation in Multiple create order helper by @ayush3797 in #2195
• Ensure environment variables works for child files. by @rohkhann in #2201
• Handle Exception during dab validate when SqlMetadataProvider has not correctly initialized by @aaronburtle in #2202
• GraphQL Queries - Entities with self-joining relationships get expected responses by @seantleonard in #2138
• Fix support for integer values in float/decimal type columns by @abhishekkumams in #2205

Enhancements

• Cosmos DB: Adds circular reference check for entities in graphQL schema by @sourabh1007 in #2192
• Validation to disallow multiple create on related entities backed by same database table by @ayush3797 in #2189
• Perform recursive authz and request validation only when multiple-create is enabled by @ayush3797 in #2199

Engineering Maintenance

• Update README.md by @Aniruddh25 in #2197
• Update Npgsql by @seantleonard in #2207
• Bump dab version in directory.build.props to 1.1 by @seantleonard in #2209

Full Changelog: v0.13.0-rc...v1.1.2-rc

0.13.0-rc: Data API Builder for Azure Databases

What's new in 0.13.0-rc

New Features

• GraphQL Multiple Create
  • Request Validation by @ayush3797 in #2057
  • Order determination for create mutations by @ayush3797 in #2056
  • Database query generation and GraphQL selection set resolution by @severussundar in #1994
• Cosmos DB: Add Patch Support (new patchEntity mutation) by @sourabh1007 in #2161

Bug Fixes

• Validate that relationship config uses backing column names for source/target fields by @aaronburtle in #2175
• Changed Error Message if Entity is not configured in dab-config json by @sourabh1007 in #2186

Engineering Fundamentals

• GitHub Codespaces support for Pull Request review (.NET6 SDK included in image) @seantleonard in #2149
• Reverting erroneous Dockerfile changes by @abhishekkumams in #2182
• Remove unneeded Dockerfile directory by @abhishekkumams in #2185
• Update Directory.Build.props to explicitly state Version 0.13 for consumption by pipelines for version stamping by @seantleonard in #2194
• Update README.md to reflect latest stable 0.11 release by @Aniruddh25 in #2176

Full Changelog: v0.12.0-rc...v0.13.0-rc

0.11.132: Data API Builder for Azure Databases

Changes:

• f517dcb [Cherrypick] Delete redundant directory (#2187) [ #2185 ]
• Fixing the container image published to use only linux build.

This list of changes was auto generated.

0.12.0-rc: Data API Builder for Azure Databases

Changes:

Bug Fixes

• 577a3f1 Fix Performance Issue for filtering on varchar columns in MS_SQL database (#2052) [ #1973 ]
• 5504205 Ensure endCursor is NULL when hasNextPage is FALSE in GraphQL response (#2121)
• 0fbf7cf Update DAB CLI to return appropriate exit codes based upon exit reason (#2084) [ #1777 ]
• aad9c17 When deploying a container app, no longer throw WorkloadProfilePropertyNotSupportedInApiVersion. DAB now uses newer containerApp API version. (Thank you, @Benjiiim!)(#2114)
• 6a75c76 No longer hang/throw unhandled exception when a table definition is not found in the database when processing relationships. (#2100) [ #2037 ]
• 08f4d45 DAB no longer emits an OpenAPI init error message in the console when DAB is configured to use CosmosDB(#2072) [ #2045 ]
• ffd29b9 Correctly resolve uniqueidentifier database type from dab-config.json defined stored proc parameter default values instead of erroring out. (#2042) [ #2027 ]
• d86a6fb Update dab start --help loglevel link to be user-readable (#2083) [ #1819 ]
• fa419cd DAB correctly handles tables with the same name, in different schemas (#1990) [ #1908 ]
• 9846181 Fix dataSourceName not found exception in dab validate (#2040) [ #2039 ]
• 8c95d76 Fix error fetching schema from URL error emitted when running dab validate. (#2099) [ #2013 ]
• 780f923 Removing wrong FK definition generated during relationship processing which results in correctly withholding redundant join condition added to t-sql query generated when traversing a relationship in GraphQL(#2051)

New Config Validation

• a23c590 Validation for relationship defined fields (#2139)
  • {source/target}
  • {source/linking-source}
  • {target/linking-target}

New Features

• a999b62 Pagination limits with config properties default-page-size and max-page-size (#2153)
• 7f7c673 Root / endpoint returns DAB Version/App User Agent (#2086) [ #1971, #1995 ]

CosmosDB New Features

• e660ba3 Cosmos DB: Item Level AuthZ (DAB config database policy support) (#2106)
• 22c0ea5 Adding In-Memory cache support for CosmosDB (#2015) [ #1884 ]
• 97d70f4 Cosmos DB: Upgrade cosmos DB SDK to latest version i.e. 3.38.1 (#2073)

See More

MSSQL: Multiple Create Functionality (Feature not activated, pending next RC release)

• 2b18315 Multiple-Create : Feature (#2122)

MSSQL Engineering Fundamentals (non-user facing changes)

• 9504f1d Change TypeName in DatabaseObject Serialization to exclude unwanted parts (#2154)
• 6ce6fe5 Update notice-generation.ps1 to fix pipeline Issue (#2151)
• dbcb651 Move Onebranch docker file out of .pipelines directory (#2142)
• 2ce1591 Add new Dockerfile for pipeline container usage (#2141) [ #2095 ]
• a937f20 Remove myself from codeowners (#2120)
• 8a3f38e Disable mssql linux test pipeline (#2076) [ #2077, #2010 ]
• 2115adf Update CODEOWNERS (#2044)
• 40142af Maintain Default Data Source Name from Original Config after Hot Reloading (#2069)
• af42ac2 Only instantiate the file watcher in a hot reloadable scenario (#2108)

DW

• 5de3682 Introduce new metadata provider initialize method (#2101)
• 31429e5 Making datasourcename mandatory during executequeryasync for multi-db scenario. (#2112)
• ae880ad executionHelper public so consumers of nuget, can call logic (#2102)
• 894cbeb Stored proc support test cases REST DW. (#2048)
• 81e42c9 Fixing nit comments from previous DW mutation support prs. (#2043)

CosmosDB - Engineering Fundamentals * 8169f86 Create a unittest pipeline, moving common steps into templates, disable CosmosDB testing on linux (#2049)

• 0920535 Cosmos DB: refactoring tests queries (#2060)
• 165ba8a Cosmos DB: Added Authorization related tests (#2034)

This list of changes was auto generated. List items were reorganized and titles were enhanced to provide more information.

0.11.130: Data API builder for Azure Databases

Changes from last release v0.11.127:

• 3834a21 Reverting back to linux image for building docker image (#2170) (#2171)

This list of changes was auto generated.

0.11.127: Data API builder for Azure Databases

Bug Fixes:

7b27830 [Cherrypick] Update onebranch Dockerfile for windows agent #2159 to release/0.11 (#2160)
dc55ef5 Update notice-generation.ps1 to fix pipeline Issue (#2151)
d763a83 [Cherrypick] Fix query string contents in nextLink for REST (remove dupe $after query parameter) (#2032) [ #2006, #1895, #1, #2 ]
c9a2125 Table name collision bug fix (#1990) (#2065)
462eb00 fixing datetime and bit issue in DW. (#1931)
27b652c Updating Service Connection for publishing dab container images (#2005)
8590aef Resolve uniqueidentifier database type from dab-config.json (#2075) [ #2042, #2027 ]
0217d3e Verifying the read access of anonymous users prior to transmitting the Mutation result. (#1893) [ #1464 ]

New Features:

446f8b2 CosmosDB: Query Filter by Id Variable support and String Array search (#2147)
f557b4d GraphQL stored procedure support for DW (#2008)
a102e44 Support environment variable serialization for data source options (#1980) [ #1956 ]
542ac92 GraphQL Mutation support for datawarehouse. (#1978)
1f3f176 Add support for app insights in CLI (#1952) [ #1745 ]
302520d Enhanced claims processing for MS SQL Set session context (#2003) [ #1957, #2004 ]
a64c277 Cache enablement check and dab-draft.schema.json changes (#2033)
3697d07 Added Cosmos Db nested Support for array type of attributes (#2009) [ #1628, #1624 ]
5fe65f8 Make relationship fields in referenced entities nullable (#1958) [ #1747 ]
2902ccb Helper methods to expose field mappings (#1918)
4d53e7e Exposing the field mappings helpers through interface. (#1965)

Performance Improvements:

36c3791 Improve Execution Performance (#1392) (#2068)

Test and Pipeline Improvements:

5c19885 Create a unittest pipeline, moving common steps into templates, disab… (#2070)
e681aa5 Migrate MYSQL and PGSQL Integration test pipeline (#1993) [ #1923 ]
bc146f3 Upgrade deprecated tasks in pipeline (#1954)

Documentation and Miscellaneous:

02463a2 Update README.md (#2028)
dacf3bc Add design doc for dab validate (#1822)
95549b1 Cleanup of redundant class (#1963)
aa577bf Update Dependencies and Suppress NU1603 (#1970)

0.11.12-rc Data API builder for Azure Databases

Changes new to 0.11.12-rc

• 8590aef Resolve uniqueidentifier database type from dab-config.json (#2075) [ #2042, #2027 ]
• c9a2125 Table name collision bug fix (#1990) (#2065) [ #1908 ]
• a64c277 Cache enablement check and dab-draft.schema.json changes (#2033) [ #2011, #2012 ]
• d763a83 Fix query string contents in nextLink for REST (remove dupe $after query parameter) (#2032) [ #2006, #1895, #1, #2 ]

Perf

• 36c3791 Improve Execution Performance (#1392) (#2068)

See More

Engineering Fundamentals added in 0.11.12-rc

• 5c19885 Create a unittest pipeline, moving common steps into templates, disab… (#2070) [ #2049 ]

Changes new to 0.11.*

DW

• 462eb00 fixing datetime and bit issue in DW. (#1931)
• 542ac92 GraphQL Mutation support for datawarehouse. (#1978)

Fundamentals and Pipelines

• 1a72c9c Add tests for built_in methods support as default field values (#1986) [ #1857, #2014 ]
• 02463a2 Update README.md (#2028)
• 27b652c Updating Service Connection for publishing dab container images (#2005)
• 02eed81 Update build-pipelines.yml (#1996)
• e681aa5 Migrate MYSQL and PGSQL Integration test pipeline (#1993) [ #1923 ]
• 4d53e7e Exposing the field mappings helpers through interface. (#1965)
• 95549b1 Cleanup of redundant class (#1963)
• aa577bf Update Dependencies and Suppress NU1603 (#1970)
• dacf3bc Add design doc for dab validate (#1822)
• bc146f3 Upgrade deprecated tasks in pipeline (#1954)
• 1d94ccc Update dwsql-pipelines.yml (#1955)
• 2902ccb Helper methods to expose field mappings (#1918)
• 2820516 update mssql pipeline for migration (#1928) [ #1923 ]

This list of changes was auto generated.

0.11.6-rc Data API builder for Azure Databases

Changes:

• f557b4d GraphQL stored procedure support for DW (#2008)
• 302520d Enhanced claims processing for MS SQL Set session context (#2003) [ #1957, #2004 ]
• a64c277 Cache enablement check and dab-draft.schema.json changes (#2033) [ #2011, #2012 ]
• d763a83 Fix query string contents in nextLink for REST (remove dupe $after query parameter) (#2032) [ #2006, #1895, #1, #2 ]
• 3697d07 Added Cosmos Db nested Support for array type of attributes (#2009) [ #1628, #1624 ]
• a102e44 Support environment variable serialization for data source options (#1980) [ #1956 ]
• 5fe65f8 Make relationship fields in referenced entities nullable (#1958) [ #1747 ]
• 1f3f176 Add support for app insights in CLI (#1952) [ #1745 ]
• 0217d3e Verifying the read access of anonymous users prior to transmitting the Mutation result. (#1893) [ #1464 ]

See More

DW

• 462eb00 fixing datetime and bit issue in DW. (#1931)
• 542ac92 GraphQL Mutation support for datawarehouse. (#1978)

Fundamentals and Pipelines

• 1a72c9c Add tests for built_in methods support as default field values (#1986) [ #1857, #2014 ]
• 02463a2 Update README.md (#2028)
• 27b652c Updating Service Connection for publishing dab container images (#2005)
• 02eed81 Update build-pipelines.yml (#1996)
• e681aa5 Migrate MYSQL and PGSQL Integration test pipeline (#1993) [ #1923 ]
• 4d53e7e Exposing the field mappings helpers through interface. (#1965)
• 95549b1 Cleanup of redundant class (#1963)
• aa577bf Update Dependencies and Suppress NU1603 (#1970)
• dacf3bc Add design doc for dab validate (#1822)
• bc146f3 Upgrade deprecated tasks in pipeline (#1954)
• 1d94ccc Update dwsql-pipelines.yml (#1955)
• 2902ccb Helper methods to expose field mappings (#1918)
• 2820516 update mssql pipeline for migration (#1928) [ #1923 ]

This list of changes was auto generated.