Add Trino Support

[snawar92]

Hello SQLFrame team,

I've been exploring SQLFrame and I'm impressed with how it implements the PySpark DataFrame API across multiple database engines. I noticed that SQLFrame currently supports BigQuery, Databricks, DuckDB, Postgres, Snowflake, and Spark, with Redshift in development.

I'm interested in using SQLFrame with Trino (formerly PrestoSQL) and was wondering if there are any plans to add Trino as a supported engine?

I understand that SQLFrame uses SQLGlot for SQL parsing and transpiling, and SQLGlot officially supports the Trino dialect. This suggests that integrating Trino support into SQLFrame could be technically feasible.

If Trino support is planned:

• Is there a rough timeline for when it might be available?

If Trino support is not currently planned:

• Would you consider a feature request for Trino support?
• Are there any specific requirements or considerations for adding a new engine that would be helpful to know?

Thank you for building and maintaining this excellent project!

[eakmanrq]

Hey @snawar92. I really like the idea of supporting Trino and it is actually the immediate use case I had for SQLFrame. The reason why it is not currently supported is that it isn't as popular as the other engines.

As a workaround, you can create a standalone session and then execute the generate SQL on Trino: https://sqlframe.readthedocs.io/en/stable/standalone

If you would like to contribute, you could open a PR with Trino support. It would likely start as a plugin and then potentially later be added to SQLFrame itself if it is popular. See some discussion about the plugin here: #550

Otherwise I don't currently have a plan to add Trino support but I do think it would be a valuable addition.