Which SQL dialect does Superintendent support?
Under the hood, Superintendent loads CSVs into a SQLite database, and every column is interpreted as string.
Please click here to learn more about the SQLite-dialect SQL.
In addition, Superintendent supports date_parse(...)
(see: doc) and regex_extract(...)
(see: doc), so it's more convenient to handle date/time and string.
If you are not familiar with SQL, you can visit the Learn SQL section to learn SQL!