[Nov2022] Data API builder for Azure Databases

This is the latest release for Data API builder for Azure Databases, version 0.4.11 (Nov2022).

New Features/ Enhancements

Engine

• Upgrade Sql Client to 5.0.1 #1027
• Managed Identity Support for Pg #1005
• Log GQL Entity Information #1025
• Clarify the usage of config files on startup #1026
• Upgrade Newtonsoft.Json to 13.0.2 #1028
• Rename and resolve left over nits #1022
• Remove limitation of nested filtering for SQL #1017
• Failing Config validation for invalid claims in SWA #1016
• Set the database name through configuration #1012
• Support AAD User authentication for Azure MySQL Service #915
• App Service Environment Detection for Production Mode #1011
• Enhanced JWT Token Claim ValueType handling for Authorization Policies #1010
• StaticWebApps Enhanced Header Payload processing #1004
• Add nested filtering GraphQL support for MsSql #994
• Reading CosmosDB options from data-source section #1003
• Enhanced AppService EasyAuth Payload Processing #985
• Config Files Generation for local development #928
• Add Graphql support for stored procedure #979
• Verify support for computed columns #1000
• Binplace dab.draft.schema.json #996
• Updating json schema for data-source section #993
• Create binaries without config files #981
• Refactor GQLFilterParser.Parse to take input BaseQueryStructure #975
• Nested Filtering For MsSql Design #957
• Adding query filter tests for second level inner object in json #954
• Adopt NuGet Central Package Management Feature and Update to .NET 6 dependencies #949

CLI

• Adding options section in data-source and removing database specific sections #980
• Renaming CLI properties for cosmosdbNoSql #991

Fixes

Engine

• Fix Manifest file creation for JsonArray with single element #978
• Fixing nullability warnings - cosmos remains #898
• Fix download url in manifest file #997
• Fixed markdown typo #995
• Handling authZ for READ operation with no fields referenced in url #953
• GraphQL HotChocolate Field Type Overflow correctly returns Http 400 Bad Request #942
• Fixed version on readme #945

CLI

• Fix Update CLI command for Stored Procedure #987

[Oct2022] Data API builder for Azure Databases

This is the latest release for Data API builder for Azure Databases, version 0.3.7 (Oct2022).

New Features/ Enhancements

Engine

• Engine startup logs runtime information #909 #543
• Improved Error Exception with precise stack trace #837
• Mutation support for views #891
• Support for Views with primary keys specified in configuration #884
• Honor Allow-Introspection property from config #889
• Introduces the authentication provider "Simulator" to effectively emulate an authenticated request in both REST and GraphQL #899
• Custom GraphQL Route Configurable Post-Startup #902
• *Cosmos Engine : Support for filter on nested objects within a document. #873
• *SQL DB: REST API entities can be backed by Stored Procedures #624

CLI

• Support creation of Views and StoredProcedure in the config using new options: #800
  • --source.type
  • --source.params
  • --source.key-fields
• Verbose(--verbose) and LogLevel(--LogLevel) Information can be configured with dab start #813

Fixes

Engine

• Correctly handles concurrent delete requests (acting on same item) #799
• Fixed handling requests containing OrderBy with int types and null values #937
• Disabled GraphQL Banana CakePop UI by default in production mode #871
• Correctly handles generation of GraphQL Mutation schema for non-mutation fields #908
• Allow GraphQL input fields to be optional when backing column has a default #901
• Fail permission validation when database policy is defined for create operation #903
• Azure AD roles detected correctly #927

CLI

• Fixed case sensitivity for --host-mode #823
• DAB will now exit in case of any inconsistencies between config and database #858 #874

[Sept2022] Data API builder for Azure Databases

This is the latest release for Data API builder for Azure Databases, version 0.2.52 (Sept2022).

New Features

Engine

• Transient Error Retry Logic
• CosmosDB support for Azure AD Managed Identities
• Authenticate-devmode-request configuration flag used to simulate the authenticated role locally in development mode without setting up Azure AD.
• Entity Definition validation for GraphQL schema creation
• Support for connecting to a database using MSI/Azure AD locally
• Support for --debug and --verbose logging options for engine execution
• Stored Procedure support in REST endpoint.
• Support for database datatype UUID
• Honors REST route path defined per Entity.

CLI

• dab init generates minimal config file
• Additional entity relationship validation
• Connection string (--connection-strting) is no longer required when initializing config with dab init

Fixes

Engine

• Correctly handles non-nullable field
• Correct handling of SWA token payload claims
• Correctly handles JSON in REST request body
• Correctly handles incorrect foreign key values in REST request
• Correctly handles null query parameters in REST requests.
• Fixed handling orderby clause columns processing during authorization.

CLI

• dab init no longer overwrites existing config file

Data API builder for Azure Databases

• This is the first (alpha) release of Data API builder (in short, dab) that provides automatic creation of GraphQL (and/or RESTful API) endpoints – to perform CRUD (Create, Read, Update and Delete) operations on entities (i.e. database objects) stored in Azure databases (Azure SQL DB, SQL Server, PostgreSQL, MySQL and Cosmos DB)
• It consists of the following major components:

1. Runtime configuration file - by default named dab-config.json that adheres to the JSON schema specified here
2. A web application service aka dab engine that supports all the properties as specified in this version of the JSON schema
3. A CLI tool named dab used to generate the config file and start the web application

Go to Getting Started to try out!