I’m wondering which version(s) of SQL does Dremio support? I suspect this might depend on the data source, but I can’t find anything about it in the docs.
Also, I’m wondering about the completeness of the built-in Functions helper and the online documentation. Are they supposed to be exhaustive? For example, I cannot find COALESCE in the helper (but it’s listed in the documentation).