OpenAPI for your Azure SQL database

Recently, a new feature called Data API builder was introduced. It allows you to convert your Azure SQL database tables, views, or stored procedures into REST endpoints that can be accessed by anyone. This feature is compatible with OpenAPI specifications and Swagger, making it easy to integrate your database with modern frontend frameworks.

An example is provided where the AdventureWorksLT sample database is converted into a REST service. The converted database can be accessed and queried using a simple REST call. Features like pagination, sorting, filtering, and field selection are supported, along with authentication and authorization.

While exposing all tables may not be ideal for production use, it can be useful for learning and experimenting with Data API builder. It is important to choose the appropriate tools for data manipulation and let the database handle it efficiently. Azure SQL Database has optimization capabilities that are difficult to replicate, such as the Adaptive Join feature.

If you want to try Data API builder in your own Azure subscription, the GitHub repository provides deployment code and a configuration file for the AdventureWorksLT sample database. Have fun exploring and learning about Data API builder!