Is there a robust DREMIO SQL Reference available?

I’m trying some queries in Dremio to build a good virtual source from a SQL Server Dataset.
I am getting invalid syntax when trying to set a variable. I can not find anything that shows all the valid SQL language commands in Dremio. I want to find the equivalent to DECLARE in T-SQL but can not find reference material to help me do this.

Also, I am getting some validation errors when I try different window functions.

Can anyone point me to a robust language reference for Dremio SQL?


Would this be helpful?

BTW - We don’t support DECLARE in Dremio SQL. We’re happy to help with any window function questions, just let us know.