DataFusion's identifier rules, applied to a SQL text before
InfluxElixir.Client.Local.SQLParser reads it (verified against
InfluxDB 3 Core):
- an unquoted identifier is folded to lower case — column, table, alias
and CTE names alike:
SELECT Host FROM Cpureads columnhostof tablecpu, andAVG(v) AS Avg_Vanswersavg_v - a double-quoted identifier keeps its case:
"Host"is columnHost - string literals (
'Abc') and$nameplaceholders are left as they are
A quoted identifier that is a plain word is written back bare, so the
parser — which folds nothing — sees its exact name. One that needs its
quotes (a space, a dot, a keyword such as "order") keeps them.
Summary
Functions
Folds unquoted identifiers to lower case and unwraps plain quoted ones.