hasura / graphql-engine

Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
https://hasura.io
Apache License 2.0
31.18k stars 2.77k forks source link

SQL as an API #9590

Open rahulagarwal13 opened 1 year ago

rahulagarwal13 commented 1 year ago

Feature Description

Ability to generate a SQL front-end from Hasura on any data source of your choice. Same experience as instant GraphQL but on SQL.

User value / outcome

SQL is still the default choice for millions of developers and data analysts around the world to work with relational databases. However, we seldom use SQL over HTTP and for API like use-cases. But what if Hasura supports standard SQL or a subset of SQL enabling business users, analysts and data scientists to use standard BI/analytics tools (such as Tableau, Qlik, MicroStrategy, Spotfire, SAS and Excel) to interact with both relational and non-relational datastores by leveraging Hasura's data connectivity framework and querying engine.

Current status (design, alpha, beta etc.)

In discovery at this stage. We would like to know more about your use-case and ideas for this feature. Any particular dialect of SQL that you would like Hasura to support?

Resources (e.g. RFCs)

Some related products include Apache Drill.

KayakinKoder commented 1 year ago

Personally, I'm astounded something like this would be worked on before improving something like Relay, which has not received any feature updates in nearly 3 years.

rahulagarwal13 commented 1 year ago

@KayakinKoder - we hear you and aim to provide Relay like improvements in V3 first. We will provide more details about it in Tanmai's keynote tomorrow. If you are interested to know more please sign up here. Also, can you please let know what kind of improvements are you looking for in Relay? The SQL as an API is an idea under consideration and has not been prioritized on the roadmap yet.