search

dask-contrib / dask-sql

Distributed SQL Engine in Python using Dask
https://dask-sql.readthedocs.io/
MIT License
385 stars 71 forks source link

[ENH] Support JSON queries #894

Open inc0 opened 1 year ago

inc0 commented 1 year ago

Is your feature request related to a problem? Please describe.

Some SQL engines, most notably Postgres, allow for JSON based queries. It would be great for Dask-SQL to support these as well.

Describe the solution you'd like

Extend SQL support to JSON-based queries, postgresql style.

Describe alternatives you've considered Alternative SQL engines, like DuckDB, already support these, but not in distributed manner.

Additional context sqlparser-rs seems to support JSON already, but I'm not sure if DataFusion does.

ayushdg commented 1 year ago

Thanks for raising this issue. @andygrove Do you happen to know offhand if datafusion supports the json syntax and generates a logic plan that we can use?

andygrove commented 1 year ago

Thanks for raising this issue. @andygrove Do you happen to know offhand if datafusion supports the json syntax and generates a logic plan that we can use?

There is no SQL JSON support as far as I know (I did just search the repo and did not see anything).