FlyQL
A lightweight, injection-proof query language that parses human-readable filter expressions into a portable AST, transpiles to SQL across ClickHouse, PostgreSQL, and StarRocks, and evaluates in-memory.
Installation
pip install flyql
Requires Python 3.10+.
Quick Start
Parse a query
from flyql import parse
result = parse("status = 200 and active")
print(result.root)
Generate SQL
from flyql import parse
from flyql.generators.clickhouse.generator import to_sql_where
from flyql.generators.clickhouse.column import Column
result = parse("status >= 400 and host like 'prod%'")
columns = {
"status": Column("status", "UInt32"),
"host": Column("host", "String"),
}
sql = to_sql_where(result.root, columns)
print(sql)
Generators are available for ClickHouse, PostgreSQL, and StarRocks:
from flyql.generators.clickhouse.generator import to_sql_where
from flyql.generators.postgresql.generator import to_sql_where
from flyql.generators.starrocks.generator import to_sql_where
Match in-memory data
from flyql import parse
from flyql.matcher import Evaluator, Record
result = parse("status = 200 and active")
data = {
"status": 200,
"active": True,
"host": "prod-api-01",
}
evaluator = Evaluator()
matches = evaluator.evaluate(result.root, Record(data))
print(f"Matches: {matches}") # True
Transformers
from flyql import parse
from flyql.generators.clickhouse.generator import to_sql_where
from flyql.generators.clickhouse.column import Column
result = parse("message|upper = 'ERROR'")
columns = {"message": Column("message", "String")}
sql = to_sql_where(result.root, columns)
print(sql) # equals(upper(message), 'ERROR')
Column parsing
from flyql.columns import parse, parse_to_json
parsed = parse("message, status")
for col in parsed:
print(f"{col.name} (display: {col.display_name!r}, segments: {col.segments})")
# Enable transformers
with_transforms = parse(
"message|chars(25) as msg, status", capabilities={"transformers": True}
)
# Serialize to JSON
json_str = parse_to_json("message, status|upper", capabilities={"transformers": True})
print(json_str)
Query Syntax
Queries consist of conditions connected by boolean operators (and, or, not):
status=200 and active and not archived
service!=api or user="john doe"
message~"error.*" and not debug
(a=1 or b=2) and not (c=3 and d=4)
status in [200, 201] and method not in ['DELETE', 'PUT']
Operators
| Operator | Syntax |
|---|---|
| Equals | = |
| Not equals | != |
| Regex match | ~ |
| Not regex match | !~ |
| Greater than | > |
| Less than | < |
| Greater or equals | >= |
| Less or equals | <= |
| In list | in |
| Not in list | not in |
| Like | like |
| Not like | not like |
| Case-insensitive like | ilike |
| Case-insensitive not like | not ilike |
Documentation
Full documentation: docs.flyql.dev
License
MIT
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
flyql-1.4.0.tar.gz
(154.7 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
flyql-1.4.0-py3-none-any.whl
(130.6 kB
view details)
File details
Details for the file flyql-1.4.0.tar.gz.
File metadata
- Download URL: flyql-1.4.0.tar.gz
- Upload date:
- Size: 154.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
b8e92d4ef0d96f85023fa7c4c5f24b5a665758e0a5c015e11004fec9be3bff5f
|
|
| MD5 |
d66f971e52963c23bbcdd98c2dae388b
|
|
| BLAKE2b-256 |
3ba7b462bc36ff193e105b783e12168cdea2b323bf4c2c71eeced8b8a4d158ae
|
Provenance
The following attestation bundles were made for flyql-1.4.0.tar.gz:
Publisher:
publish.yaml on iamtelescope/flyql
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
flyql-1.4.0.tar.gz -
Subject digest:
b8e92d4ef0d96f85023fa7c4c5f24b5a665758e0a5c015e11004fec9be3bff5f - Sigstore transparency entry: 2702630058
- Sigstore integration time:
-
Permalink:
iamtelescope/flyql@5293436aabfc525f8e41d43513e7bf4a81b0c4a7 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/iamtelescope
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yaml@5293436aabfc525f8e41d43513e7bf4a81b0c4a7 -
Trigger Event:
workflow_dispatch
-
Statement type:
File details
Details for the file flyql-1.4.0-py3-none-any.whl.
File metadata
- Download URL: flyql-1.4.0-py3-none-any.whl
- Upload date:
- Size: 130.6 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
dc6fba722b39e18a10665c999aa65a52caa8f7a2b6a260c90391e1ae6495f690
|
|
| MD5 |
960958a3f71c5bd9027d413618fc22fb
|
|
| BLAKE2b-256 |
93167d1964f24b72eaf6cc7fac1478b1fd4ca6de2e5301064b98e6c427c8019a
|
Provenance
The following attestation bundles were made for flyql-1.4.0-py3-none-any.whl:
Publisher:
publish.yaml on iamtelescope/flyql
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
flyql-1.4.0-py3-none-any.whl -
Subject digest:
dc6fba722b39e18a10665c999aa65a52caa8f7a2b6a260c90391e1ae6495f690 - Sigstore transparency entry: 2702630106
- Sigstore integration time:
-
Permalink:
iamtelescope/flyql@5293436aabfc525f8e41d43513e7bf4a81b0c4a7 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/iamtelescope
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yaml@5293436aabfc525f8e41d43513e7bf4a81b0c4a7 -
Trigger Event:
workflow_dispatch
-
Statement type:
