Skip to content

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

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 (in progress)
  • Hive
  • Materialize
  • MySQL
  • SingleStore (uses the MySQL dialect)
  • PRQL
  • Oracle
  • Postgres
  • Presto
  • Redshift
  • RisingWave
  • SQLite
  • Snowflake
  • Spark (note: need to determine difference between Spark vs Spark2 dialect and which should be supported, if not both)
  • StarRocks
  • TSQL
  • Tableau
  • Teradata
  • Trino

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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