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.2.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.2.0-py3-none-any.whl
(130.6 kB
view details)
File details
Details for the file flyql-1.2.0.tar.gz.
File metadata
- Download URL: flyql-1.2.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 |
81c1b883c248980a0e43ad186c4218bde90951a2e88424c68f8c346c151b08c1
|
|
| MD5 |
ab44ddee0fa867d4ebcbc9cd00289694
|
|
| BLAKE2b-256 |
15ce44f13d5276fd6436dae2e280c45288ec99c8338ddef56cb6826fa0742a07
|
Provenance
The following attestation bundles were made for flyql-1.2.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.2.0.tar.gz -
Subject digest:
81c1b883c248980a0e43ad186c4218bde90951a2e88424c68f8c346c151b08c1 - Sigstore transparency entry: 2569640968
- Sigstore integration time:
-
Permalink:
iamtelescope/flyql@348787569ac1ae049f96eec55fe951b039378e37 -
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@348787569ac1ae049f96eec55fe951b039378e37 -
Trigger Event:
workflow_dispatch
-
Statement type:
File details
Details for the file flyql-1.2.0-py3-none-any.whl.
File metadata
- Download URL: flyql-1.2.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 |
6bf3d7f4191b8127bd3f3050c6af3fe36172510fb49f1236c5ff46e51fdeeb92
|
|
| MD5 |
c0abe24574c5048653a87bdbe4d011dc
|
|
| BLAKE2b-256 |
c4fbdfd6bf3949055ddc15c08c795521b6b05a34e129a330583238c0964ff80e
|
Provenance
The following attestation bundles were made for flyql-1.2.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.2.0-py3-none-any.whl -
Subject digest:
6bf3d7f4191b8127bd3f3050c6af3fe36172510fb49f1236c5ff46e51fdeeb92 - Sigstore transparency entry: 2569640973
- Sigstore integration time:
-
Permalink:
iamtelescope/flyql@348787569ac1ae049f96eec55fe951b039378e37 -
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@348787569ac1ae049f96eec55fe951b039378e37 -
Trigger Event:
workflow_dispatch
-
Statement type:
