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.3.0.tar.gz
(154.6 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.3.0-py3-none-any.whl
(130.6 kB
view details)
File details
Details for the file flyql-1.3.0.tar.gz.
File metadata
- Download URL: flyql-1.3.0.tar.gz
- Upload date:
- Size: 154.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
e8a13c19b02c132e21ddffa6d79639b4ec749221502055ba95d975ffc3350871
|
|
| MD5 |
8c1295c19b6eb9ffac99ec7c10b9093f
|
|
| BLAKE2b-256 |
77be2a3ed10ac82af64c098f772647ee677688685a1b67e994e3d89806d6096b
|
Provenance
The following attestation bundles were made for flyql-1.3.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.3.0.tar.gz -
Subject digest:
e8a13c19b02c132e21ddffa6d79639b4ec749221502055ba95d975ffc3350871 - Sigstore transparency entry: 2697066985
- Sigstore integration time:
-
Permalink:
iamtelescope/flyql@b4a300e8fb9b340ea51fd6fddc998cbd88d18bfc -
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@b4a300e8fb9b340ea51fd6fddc998cbd88d18bfc -
Trigger Event:
workflow_dispatch
-
Statement type:
File details
Details for the file flyql-1.3.0-py3-none-any.whl.
File metadata
- Download URL: flyql-1.3.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 |
1850b888ee411603bfb3f39d7219c57b1e6eba11c003acd1512b05dfaa3a32f0
|
|
| MD5 |
f3a3796fcec4fd6565238013f586ec35
|
|
| BLAKE2b-256 |
e659ac844e477b6f72768beb1444589c75b62e49b0c3bdd4111a428acb5d1560
|
Provenance
The following attestation bundles were made for flyql-1.3.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.3.0-py3-none-any.whl -
Subject digest:
1850b888ee411603bfb3f39d7219c57b1e6eba11c003acd1512b05dfaa3a32f0 - Sigstore transparency entry: 2697067016
- Sigstore integration time:
-
Permalink:
iamtelescope/flyql@b4a300e8fb9b340ea51fd6fddc998cbd88d18bfc -
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@b4a300e8fb9b340ea51fd6fddc998cbd88d18bfc -
Trigger Event:
workflow_dispatch
-
Statement type:
