Skip to main content

Convenience wrapper for exonware-xwquery - provides 'import xwquery' alias

Project description

xwquery

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

Query and transform native Python data structures with one API: SQL-style scripts, graph patterns, aggregations, and 35+ alternate surface syntaxes (Cypher, GraphQL, JMESPath, and others). It works directly with dictionaries, lists, and mixed in-memory structures; xwnode, xwdata, and xwentity integrations are optional add-ons when you want deeper stack features.

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

xwquery-0.9.0.8.tar.gz (496.5 kB view details)

Uploaded Source

Built Distribution

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

xwquery-0.9.0.8-py3-none-any.whl (6.3 kB view details)

Uploaded Python 3

File details

Details for the file xwquery-0.9.0.8.tar.gz.

File metadata

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

File hashes

Hashes for xwquery-0.9.0.8.tar.gz
Algorithm Hash digest
SHA256 ebb1b8cd2c05f95066c6e516de908a05606d55390ce602bd84bc006aed924111
MD5 4b4d6268b5de90d79d919456b0fa0d8f
BLAKE2b-256 2b8407b01950313d841c8c7c41827c0f8d75fac2ff46badeedde9ba02d316997

See more details on using hashes here.

File details

Details for the file xwquery-0.9.0.8-py3-none-any.whl.

File metadata

  • Download URL: xwquery-0.9.0.8-py3-none-any.whl
  • Upload date:
  • Size: 6.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.12.13

File hashes

Hashes for xwquery-0.9.0.8-py3-none-any.whl
Algorithm Hash digest
SHA256 3826650dba1e9be7caec9e54067908557d6ca1920d1bf7b65f747911002bcac3
MD5 46e8cf0199106ac60825f3e99c188fd3
BLAKE2b-256 a0e4d1f78cfdd47d97918c317064a6a520b92cec5a070f18102751fc7f23ca44

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