waveql 0.1.7

Universal Python connector for APIs - Query any data source with SQL

WaveQL

The Universal SQL Connector for Modern APIs
Query ServiceNow, Salesforce, Jira, and more using standard SQL.

---

WaveQL unifies SaaS APIs (ServiceNow, Salesforce, Hubspot), Databases, and Files under a standard SQL interface. It translates your SQL into optimized API calls (pushing down predicates like WHERE and ORDER BY) and handles pagination/auth automatically.

🚀 Quick Start

pip install waveql

import waveql

# Connect to any source
conn = waveql.connect("servicenow://instance.service-now.com", username="admin", password="password")

# Run standard SQL (We handle the API translation)
cursor = conn.cursor()
cursor.execute("""
    SELECT number, short_description 
    FROM incident 
    WHERE priority = 1 
    ORDER BY number DESC 
    LIMIT 5
""")

print(cursor.to_df())  # Returns Pandas DataFrame

📚 Documentation

Topic	Description
Adapters	Supported sources (ServiceNow, Salesforce, etc.)
Architecture	System diagram & components
Configuration	Auth, Caching, and Paths
Transactions	Saga Pattern & Atomic Writes
CDC	Real-time Change Data Capture
Semantic Layer	Virtual Views & dbt integration

Contributors: Read AGENTS.md.

✨ Key Features

• Universal SQL: Join servicenow.incident with salesforce.account.
• Smart Pushdown: WHERE converts to JQL/SOQL automatically.
• Zero-Copy: Built on DuckDB + PyArrow.
• Async Native: async/await throughout.
• Production Ready: Retries, rate-limiting, and pooling.

License

MIT.