Building a GraphQL to SQL Compiler on Postgres, MS SQL and MySQL

The Hasura team has released version 2.0 with support for multiple database backends, including Microsoft SQL Server. They plan to add more backends like Google BigQuery, MySQL, and Citus in the future. However, different databases have varying levels of SQL feature support, which poses challenges when generalizing Hasura features across all backends. The team is working on abstractions for code generation, querying functionality, subscriptions, action relationships, and other language features to address these issues. They aim to provide a compact set of abstractions with clear semantics and reference implementations for each backend.