FlyQL Playground
Build a FlyQL query and compile it into parameterized SQL for ClickHouse, PostgreSQL, and StarRocks — or match it in-memory against sample access log records. The sidebar on the right shows FlyQL column types and the dialect-specific types each generator emits against.
The SELECT list. Accepts column names, transformers like |lower, and aliases (as Method).
ColumnsThe WHERE clause. Values are passed as SQL parameters, never interpolated into the query.
QueryThe query is compiled to parameterized SQL for each dialect. Values are passed as query parameters — never interpolated into the SQL string.
Type a query above and click Run
FlyQL Columns
statusint
methodstring
hoststring
pathstring
requestjson
ClickHouse Columns
statusUInt16
methodString
hostString
pathString
requestJSON