[Jan2023] Data API builder for Azure Databases

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

New Features

Engine

• Adding support for nullable/varchar(*) result columns for stored-procedure by @abhishekkumams in #1038
• Removing devmode auth flag from config by @ayush3797 in #1040
• Add support for stored procedure with non-empty mutation response by @abhishekkumams in #1058
• Add support for graphQL type name for stored procedure by @abhishekkumams in #1060
• Add nuget download url to manifest file by @abhishekkumams in #1071
• Update ConfigurationController to return BadRequest on failure and wait for Init to complete by @Mathos1432 in #1074
• Allow correlation Id pass through requests by @tarazou9 in #1054
• Categorizing Conflict error codes by @ayush3797 in #1090
• Runtime to Database Authorization for MsSql - Session Context by @ayush3797 in #1084
• Create NuGet and Zip files without development/testing files by @severussundar in #1091
• Update Npgsql version by @Aniruddh25 in #1087
• Updating reference config file by @ayush3797 in #1111
• Prevent introspection field __typename from being evaluated as an Entity Field by @seantleonard in #1086
• Modify release suffix to beta by @Aniruddh25 in #1115
• Allow comments in config file by @ayush3797 in #1109
• Updating json schema for Stored Procedure by @ayush3797 in #1116
• Update dab package names to Microsoft.DataApiBuilder by @abhishekkumams in #1135
• Obtaining cosmos Database name from connection string by @mbhaskar in #1120
• GraphQL Query/Mutation Entity Field mapping support by @seantleonard in #1114
• Mandate encryption and validation of SQL server certificate when late configured by @Aniruddh25 in #1134
• Log Query Information by @aaronburtle in #1141
• Logging Primary Keys by @aaronburtle in #1147
• fixing logs for add command by @abhishekkumams in #1148
• Publishing Microsoft.DataApiBuilder nuget to Nuget.org by @abhishekkumams in #1118
• Logging request authenticated status and Role by @ayush3797 in #1146
• Adding tests for pg nested filtering by @gledis69 in #1149
• Stored Procedure support for new Execute operation - REST and GraphQL by @seantleonard in #1107
• Add --no-https-redirect option to start command for disabling forced https redirects. by @abhishekkumams in #1161
• Support GraphQL List of scalar by @aaronpowell in #1165
• SslMode = VerifyFull for MySQL and PostgreSQL in late configuration by @Aniruddh25 in #1178
• Logging Column Relationship Information by @aaronburtle in #1164
• Make default loglevel debug and error for dev and prod respectively by @abhishekkumams in #1182

CLI

• Use ILogger to print CLI logs by @abhishekkumams in #1039
• Cli check for stored procedure Operations by @abhishekkumams in #1041
• dab cli to use generated online schema in config by @abhishekkumams in #1059
• Allowing user to specify session context bool property from CLI by @ayush3797 in #1064
• Add DAB version as the first line logged by @Aniruddh25 in #1106
• Add support for authentication option to cli "init" command by @abhishekkumams in #1079

Bug Fixes

Engine

• Removing references to Cosmos Database in CLI/Engine/Pipelines/Config file names/Build commands. by @ayush3797 in #1045
• Fix primary route path error for REST calls with Stored-procedure mutation by @abhishekkumams in #1069
• Fix dab config schema $id by @Aniruddh25 in #1102
• Examine docker image for schema and config files by @severussundar in #1110
• Remove cosmos nullability warnings appearing during build by @tarazou9 in #1140
• Rename to PackageProjectUrl property by @Aniruddh25 in #1188
• Add project url property to nuspec by @Aniruddh25 in #1187
• Create separate README for nuget by @Aniruddh25 in #1186
• Fixing build warnings by @ayush3797 in #1160
• Fix $orderBy for floating type, non-primary key non-selected and mapped columns by @Aniruddh25 in #1144
• Fix stored procedure mutation REST incomplete result by @abhishekkumams in #1072
• Fix missing supported types for $filter clause in REST by @Aniruddh25 in #1112
• Update Codeowners by @Aniruddh25 in #1145
• Update JSON schema from method to methods for REST configuration by @seantleonard in #1157

CLI

• Skip generation of multiple config files along with build by @severussundar in #1029
• Fixing update command for stored-procedure in cli by @abhishekkumams in #1062
• Replacing missed console statements to Ilogger in CLI by @abhishekkumams in #1065
• Fixing the incorrect error code even when CLI exits correctly by @abhishekkumams in #1151
• Updating the logic of fetching the graphQL Operation for SP by @severussundar in #1171
• Update error message for missing entity in CLI Command by @abhishekkumams in #1077
• fix duplicate version logs by @abhishekkumams in #1137

Docs

• Fix broken links in the getting-started docs by @abhishekkumams in #1046
• Updated stored procedure support notes by @yorek in #1057
• Doc update stored procedure by @abhishekkumams in #1067
• Getting started doc for Mysql by @mksuni in #984
• Fix known issues documentation by @Aniruddh25 in #1185
• Update using DAB Cli with loglevel information by @aaronburtle in #1183
• Initial documentation update for PostgreSQL support by @GaryHopeMS in #1089
• Update known-issues.md by @mksuni in #1105
• Docs -> Stored Procedure - Execute | methods | operation by @seantleonard in #1163
• [DOC] Runtime to Database Authorization - SESSION_CONTEXT for MsSql by @ayush3797 in #1094

New Contributors

• @mksuni made their first contribution in #984
• @GaryHopeMS made their first contribution in #1089

Full Changelog: v0.4.11-alpha...v0.5.0-beta

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