[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!