Skip to content

Support to_table() with BodoSQL Dialect #500

@hadia206

Description

@hadia206

pydough.to_table() is added in #493 to materialize PyDough queries as database tables/views. It currently supports SQLite, Snowflake, MySQL, Postgres, and Oracle.

BodoSQL uses a different execution model (BodoSQLContext instead of DB connection) and needs separate handling.

Tasks

  • Identify how BodoSQL supports CREATE TABLE/VIEW
  • Implement DDL execution path for BodoSQLContext
  • Add CreateCapabilities entry for DatabaseDialect.BODOSQL
  • Add integration tests

follows up on #493

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions