Skip to content

Add support for other SQLGlot-supported databases in PyDough #229

@knassre-bodo

Description

@knassre-bodo

The following databases have dialects in SQLGlot. The goal of this overarching issue is to ensure each is supported in Pydough, or at least. Each dialect, once examined, should either have an issue opened to support the dialect or should be crossed off the list with a justificaiton for why it is not being considered as part of this issue. Once a dialect is supported, its box can be checked off. Support for a dialect entails support for a connection to it in a PyDough Database context, handling for all PyDough functions in the function transform bindings, e2e testing to confirm that execution with the database is functional, and adding all appropriate user documentation.

  • Athena
  • BigQuery
  • ClickHouse
  • Databricks
  • Doris
  • Drill
  • DuckDB
  • Hive
  • Materialize
  • MySQL (in progress)
  • SingleStore (uses the MySQL dialect)
  • Oracle
  • PRQL
  • Postgres (in progress)
  • Presto
  • Redshift
  • RisingWave
  • SQLite
  • Snowflake (in progress)
  • Spark (note: need to determine difference between Spark vs Spark2 dialect and which should be supported, if not both)
  • StarRocks
  • TSQL
  • Tableau
  • Teradata
  • Trino

Sub-issues

Metadata

Metadata

Assignees

No one assigned

    Labels

    documentationImprovements or additions to documentationeffort - highmajor issue that will require multiple steps or complex designenhancementNew feature or requesthelp wantedExtra attention is neededtestingAlters the testing/CI process for PyDoughuser featureAdding a new user-facing feature/functionality

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions