hello,
We are conducting a proof of concept for a data lake solution utilizing Amazon S3 with Iceberg tables, managed via the AWS Glue Catalog, and queried with AWS EMR and Trino. We currently have a significant number of SQL reports implemented through SQL stored procedures on a SQL Server database, which we intend to migrate to the new data lake solution.

I would like to know if Trino supports variable declaration, as I encountered issues with this while using DBeaver. Additionally, does Trino support the creation of temporary tables, which are frequently used in our SQL stored procedures?

I am looking at https://trino.io/docs/current/routines/declare.html

declare my_var int;
SQL Error [1]: Query failed (#20241127_232503_00122_p5vur): line 1:1: mismatched input 'declare'. Expecting: 'ALTER', 'ANALYZE', 'CALL', 'COMMENT', 'COMMIT', 'CREATE', 'DEALLOCATE', 'DELETE', 'DENY', 'DESC', 'DESCRIBE', 'DROP', 'EXECUTE', 'EXPLAIN', 'GRANT', 'INSERT', 'MERGE', 'PREPARE', 'REFRESH', 'RESET', 'REVOKE', 'ROLLBACK', 'SET', 'SHOW', 'START', 'TRUNCATE', 'UPDATE', 'USE', 'WITH',

If support for these 2 features are not there; is there any workaround ?

thanks
sukh