Skip to main content

Universal query language for data structures - 50+ operations, 35+ format converters

Project description

xwquery

Company: eXonware.com
Author: eXonware Backend Team
Email: connect@exonware.com

Query and transform in-memory data with one API: SQL-style scripts, graph patterns, aggregations, and 35+ alternate surface syntaxes (Cypher, GraphQL, JMESPath, and others). Built to pair with xwnode, xwdata, and xwentity in the eXonware stack.

Install

pip install exonware-xwquery

Basic usage

from exonware.xwquery import XWQuery

data = {'users': [
    {'name': 'Alice', 'age': 30, 'city': 'NYC'},
    {'name': 'Bob', 'age': 25, 'city': 'LA'},
    {'name': 'Charlie', 'age': 35, 'city': 'NYC'}
]}

result = XWQuery.execute("""
    SELECT name, age
    FROM users
    WHERE age > 25 AND city = 'NYC'
""", data)

print(result)
# [{'name': 'Alice', 'age': 30}, {'name': 'Charlie', 'age': 35}]

What you get

  • Broad operation set - Core CRUD (SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP), filtering (WHERE, FILTER, LIKE, IN, RANGE, …), aggregation (GROUP BY, HAVING, SUM, COUNT, …), graph helpers (MATCH, PATH, …), and advanced pieces (JOIN, UNION, WITH, WINDOW, PIPE, …).
  • Many input languages - Strategies for SQL-family dialects, Cypher/Gremlin/SPARQL/GraphQL, document and log query languages (MQL, Elasticsearch DSL, PromQL, Flux, …), and more. Parse or convert between them where supported.
  • Structure-aware execution - The engine can adapt work to linear, tree, graph, or hybrid shapes when the backend exposes that metadata.
linear_data = [1, 2, 3, 4, 5]
tree_data = {'a': 1, 'b': 2, 'c': 3}
graph_data = {'nodes': [...], 'edges': [...]}

XWQuery.execute("SELECT * WHERE value > 2", linear_data)
XWQuery.execute("SELECT * WHERE key BETWEEN 'a' AND 'c'", tree_data)
XWQuery.execute("MATCH (n)-[r]->(m)", graph_data)

Script examples

SELECT name, email, age FROM users WHERE age >= 18;

SELECT department, COUNT(*) AS employee_count, AVG(salary) AS avg_salary
FROM employees
GROUP BY department
HAVING avg_salary > 50000;

MATCH (u:User)-[:FRIENDS_WITH]->(f:User)
WHERE u.age > 25
RETURN u.name, f.name;

Format conversion

sql_query = "SELECT id, name FROM users WHERE age > 25"
graphql = XWQuery.convert(sql_query, from_format='sql', to_format='graphql')

cypher_query = "MATCH (u:User)-[:WORKS_AT]->(c:Company) RETURN u.name, c.name"
sql = XWQuery.convert(cypher_query, from_format='cypher', to_format='sql')

any_query = XWQuery.parse(query_string)
target_format = any_query.to_format('mongodb')

Stack integration

xwnode

from exonware.xwnode import XWNode
from exonware.xwquery import XWQuery

node = XWNode.from_native({'users': [...]})
result = XWQuery.execute("SELECT * FROM users WHERE active = true", node)

xwdata

from exonware.xwdata import XWData
from exonware.xwquery import XWQuery

data = XWData.load('users.json')
filtered = XWQuery.execute("SELECT * WHERE age > 18", data)
filtered.save('adults.xml')

xwentity

from exonware.xwentity import XWEntity
from exonware.xwquery import XWQuery

class User(XWEntity):
    name: str
    age: int
    email: str

users = XWQuery.execute("SELECT * FROM User WHERE age > 18")

Docs

Development

pip install -e .
python tests/runner.py
python tests/runner.py --core
python tests/runner.py --unit
python tests/runner.py --integration

License

MIT - see LICENSE.

Ecosystem

Built with ❤️ by eXonware.com - Revolutionizing Python Development Since 2025

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

exonware_xwquery-0.9.0.6.tar.gz (496.3 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

exonware_xwquery-0.9.0.6-py3-none-any.whl (756.8 kB view details)

Uploaded Python 3

File details

Details for the file exonware_xwquery-0.9.0.6.tar.gz.

File metadata

  • Download URL: exonware_xwquery-0.9.0.6.tar.gz
  • Upload date:
  • Size: 496.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.12.13

File hashes

Hashes for exonware_xwquery-0.9.0.6.tar.gz
Algorithm Hash digest
SHA256 90c8eecff88e99c40344c16ef59d1759a341cf0663c77dc81b597edade962119
MD5 1bc1f78467a7ec24529bb2551b342732
BLAKE2b-256 89afed841687708c29018f47ae7f69f5fcacfeb15510b379db71a92170f42ea8

See more details on using hashes here.

File details

Details for the file exonware_xwquery-0.9.0.6-py3-none-any.whl.

File metadata

File hashes

Hashes for exonware_xwquery-0.9.0.6-py3-none-any.whl
Algorithm Hash digest
SHA256 7ddffb33657af8ec591cab027fb0868181219ceed808ff0e4251e95c018f7ece
MD5 8164570fa374cabc7d88847cb5931925
BLAKE2b-256 4b8d0e27f9e63b8c4851346d51894e3996c143ef52376aa3e8da39bd58cf5e99

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page