Skip to main content

Orange3-SQLQuery

This allows use DuckDB to perform SQL queries on multiple input tables from duckdb, json, json line (jsonl) files, and anything else that DuckDB supports.

Installation

Within the Add-ons installer, click on "Add more..." and type in orange3-sqlquery

Provided Widgets

This addon provides 4 widgets

Widget Line Up

DuckDB Table

DuckDB Table Widget

JSON Loader

JSON Loader Widget

JSON Lines Loader (and description)

JSON Lines Loader Widget

SQL Query Widget

SQL Query Widget

Example Workflow

Example Orange3 workflow using SQLQuery to join 2 tables, one with Iranian rainfall per city and another with the coordinates of Iranian cities, the SQL statement also limits to cities whose latitude is less than 30.

Release files for orange3-sqlquery 0.0.4

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for orange3-sqlquery 0.0.4
File Size Uploaded
orange3_sqlquery-0.0.4.tar.gz 206.9 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for orange3-sqlquery 0.0.4
File Interpreter ABI Platform
orange3_sqlquery-0.0.4-py3-none-any.whl Python 3 none any Details

Total release size: 416.9 kB

Release files / orange3_sqlquery-0.0.4.tar.gz

Download URL orange3_sqlquery-0.0.4.tar.gz
Size 206.9 kB
Tags Source
SHA-256 checksum
How to use checksums
dd9f5425089c0183c37bcf9233ea39280f505dfa498875ee9abb4b9dfa69a1c5
BLAKE2b-256 checksum
How to use checksums
bd5ced4a73eca90c5c1db242765081a4cd4b44d068b5acdd5c2cbf27fc0dca0a
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.12.11

Release files / orange3_sqlquery-0.0.4-py3-none-any.whl

Download URL orange3_sqlquery-0.0.4-py3-none-any.whl
Size 210.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
f021fe256700c171b81513f9c097dbf1bdece68db67791da36fe7352c388be69
BLAKE2b-256 checksum
How to use checksums
cadcd7e7ef5d4b95b686420aea7399b172eede3835783f5249b196d0d0a5a174
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.12.11

Release history Release notifications | RSS feed

This release

0.0.4 This release

2 release files

0.0.3

2 release files

0.0.2

2 release files

0.0.1

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page