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.1.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.1.0-py3-none-any.whl
(130.6 kB
view details)
File details
Details for the file flyql-1.1.0.tar.gz.
File metadata
- Download URL: flyql-1.1.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 |
0429e7afa66df001db4f3f03640870905d838bb325365d71ddac1f0be37e5465
|
|
| MD5 |
63ae743c986cdea8285e5e1e57ce600c
|
|
| BLAKE2b-256 |
2b5b62f59a2e786dc7eaa03155bb80e5c230ccee3b38aca3faf39e1eae521764
|
Provenance
The following attestation bundles were made for flyql-1.1.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.1.0.tar.gz -
Subject digest:
0429e7afa66df001db4f3f03640870905d838bb325365d71ddac1f0be37e5465 - Sigstore transparency entry: 2437971206
- Sigstore integration time:
-
Permalink:
iamtelescope/flyql@45c7c7a10446abf7b17acc5803571884c09c3679 -
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@45c7c7a10446abf7b17acc5803571884c09c3679 -
Trigger Event:
workflow_dispatch
-
Statement type:
File details
Details for the file flyql-1.1.0-py3-none-any.whl.
File metadata
- Download URL: flyql-1.1.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 |
6ca9a56da8c4a15646a0d71f0b66c0b7130594c557fe1f50621657a3339c3e7b
|
|
| MD5 |
606210d74943c926ae24aa73ea89fc1c
|
|
| BLAKE2b-256 |
9a7d8abb1566a5fb432e1f31e5f599709230084694f38b2eb5fad1c107825a71
|
Provenance
The following attestation bundles were made for flyql-1.1.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.1.0-py3-none-any.whl -
Subject digest:
6ca9a56da8c4a15646a0d71f0b66c0b7130594c557fe1f50621657a3339c3e7b - Sigstore transparency entry: 2437971297
- Sigstore integration time:
-
Permalink:
iamtelescope/flyql@45c7c7a10446abf7b17acc5803571884c09c3679 -
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@45c7c7a10446abf7b17acc5803571884c09c3679 -
Trigger Event:
workflow_dispatch
-
Statement type:
