Skip to main content

Simple widget to load a table from an SQL query against an SQLite3 database

Project description

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.

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

orange3_sqlquery-0.0.4.tar.gz (206.9 kB view details)

Uploaded Source

Built Distribution

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

orange3_sqlquery-0.0.4-py3-none-any.whl (210.0 kB view details)

Uploaded Python 3

File details

Details for the file orange3_sqlquery-0.0.4.tar.gz.

File metadata

  • Download URL: orange3_sqlquery-0.0.4.tar.gz
  • Upload date:
  • Size: 206.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.12.11

File hashes

Hashes for orange3_sqlquery-0.0.4.tar.gz
Algorithm Hash digest
SHA256 dd9f5425089c0183c37bcf9233ea39280f505dfa498875ee9abb4b9dfa69a1c5
MD5 2d1d267a462c3de56af65ef9e52824bc
BLAKE2b-256 bd5ced4a73eca90c5c1db242765081a4cd4b44d068b5acdd5c2cbf27fc0dca0a

See more details on using hashes here.

File details

Details for the file orange3_sqlquery-0.0.4-py3-none-any.whl.

File metadata

File hashes

Hashes for orange3_sqlquery-0.0.4-py3-none-any.whl
Algorithm Hash digest
SHA256 f021fe256700c171b81513f9c097dbf1bdece68db67791da36fe7352c388be69
MD5 f1e5338428f9b4bc16c7226e833d839d
BLAKE2b-256 cadcd7e7ef5d4b95b686420aea7399b172eede3835783f5249b196d0d0a5a174

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