Unable to parse Trino dialect

[zverok]

Search before asking

• I searched the issues and found no similar issues.

What Happened

Unable to parse any query in the Trino dialect.
I searched through existing issues, and it seems that nobody has reported the problem.

And judging by the feature requests for some Trino features support, it typcially works, i.e. the problem doesn’t affect other people and should be specific to my setup, but I can’t guess what it might be.

Expected Behaviour

sqlfluff parse some_code.sql -d trino prints the parse tree

Observed Behaviour

$ sqlfluff parse scripts/tmp/test.sql -d trino
RuntimeError: Grammar refers to the 'Transient' keyword which was not found in the trino dialect.

The syntax in the query is not (yet?) supported. Try to narrow down your query to a minimal, reproducible case and raise an issue on GitHub.

Or, even better, see this guide on how to help contribute keyword and/or dialect updates:
https://github.com/sqlfluff/sqlfluff/wiki/Contributing-Dialect-Changes#keywords

How to reproduce

Content of test.sql might be any, in this case, say

create table users as (select name, email from old_users);

The error never changes regardless of the content of the file.

Dialect

Trino

Version

$ sqlfluff --version
sqlfluff, version 3.0.6

$ python --version
Python 3.11.6

Configuration

Are you willing to work on and submit a PR to address the issue?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct