1.1.7: Data API builder for Azure Databases

[seantleonard]

What's Changed

New Features

• Multiple db support for REST scenario Multiple db support for REST scenario #2169
• .NET 8 multi-targetting .NET 8 Upgrade (Multi Framework targetting) #2181
• GraphQL Multiple Create for MSSQL Multiple-Create : Feature #2122
  • Request Validation Multiple-create: Request Validation #2057
  • Order determination for create mutations Multiple-create: Order determination for insertions #2056
  • Database query generation and GraphQL selection set resolution Multiple Create - Database Query Generation and Selection Set Resolution #1994
• Pagination limits with config properties default-page-size and max-page-size Adding pagination limits. #2153
• Root / endpoint returns DAB Version/App User Agent Improved Health Endpoint Metadata (DAB Version/App User Agent) #2086
• PostgreSQL: Supplement application name in connection string Add application name for PGSQL connections #2208
• Cosmos DB: Patch Support (via new patchEntity mutation) Cosmos DB: Adds Patch Support #2161
• Cosmos DB: Item Level AuthZ enabled by database policies Cosmos DB: Adds Item Level Auth support using DB Policy #2106
• Cosmos DB: Adding In-Memory cache support Adding In-Memory cache support for CosmosDB #2015

New Config Validation

• Validation for relationship defined fields Add validation for source and target fields in relationships #2139
  • {source/target}
  • {source/linking-source}
  • {target/linking-target}
• CosmosDB circular reference validation for entities in GraphQL schema Cosmos DB: Adds circular reference check for entities in graphQL schema #2192
• Validation against unsupported scenario: multiple create on related entities backed by same database table Validation to disallow multiple create on related entities backed by same database table #2189

Bug Fixes

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

• dab validate Returns proper error message when validations can't proceed due to invalid/no connection string. Handle Exception during dab validate when SqlMetadataProvider has not correctly initialized #2202

• dab validate Relationships must define source/target/linking fields using table column names (not field aliases) Validate relationship field names in config as backing columns #2175

• dab validate Fix dataSourceName not found exception Fix dataSourceName not found exception in dab validate #2040

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

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

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

• GraphQL - Ensure endCursor is NULL when hasNextPage is FALSE in response Ensure endCursor is NULL when hasNextPage is FALSE in GraphQL 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 Changed Error Message if Entity is not configured 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 Condition OpenAPI document creation to non-CosmosDB database types. #2072

• DAB CLI - Returns appropriate exit code based upon exit reason Update DAB CLI to return appropriate exit codes based upon exit reason #2084

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

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

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

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

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

• Ensure environment variables works for child files 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. Resolve uniqueidentifier database type from dab-config.json defined stored proc parameter default values. #2042

• DAB correctly handles tables with the same name, in different schemas Table name collision bug fix #1990

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

Engineering Maintenance

• Update Npgsql to 7.0.7 for .NET6 Update Npgsql to 7.0.7 for net6  #2214
• Update Npgsql to 8.0.3 for .NET8 Update Npgsql #2207
• Set DAB version to 1.1 in directory.build.props Bump dab version in directory.build.props to 1.1 #2209
• GitHub Codespaces support for Pull Request review (.NET6 SDK included in image) add devcontainer.json config for .net 6 -Codespaces #2149

Documentation

• Updates support.md page Updates support #2216

See More (non-user facing changes)

MSSQL Engineering Fundamentals

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

DW

• Introduce new metadata provider initialize method Introduce new metadata provider initialize method  #2101
• Multi-DB: Making datasourcename mandatory during executequeryasync Making datasourcename mandatory during executequeryasync for multi-db scenario. #2112
• executionHelper access modifer set to public executionHelper public so consumers of nuget, can call logic #2102
• Stored proc support test cases REST DW. Stored proc support test cases REST DW. #2048
• Fixing nit comments from previous DW mutation support prs. Fixing nit comments from previous DW mutation support prs. #2043

CosmosDB - Engineering Fundamentals

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

---

This discussion was created from the release 1.1.7: Data API builder for Azure Databases.