Metadata-Version: 2.4
Name: orange3-sqlquery
Version: 0.0.4
Summary: Simple widget to load a table from an SQL query against an SQLite3 database
Author-email: Chris Lee <github@chrislee.dhs.org>
License: CC-BY-NC-SA-4.0
Project-URL: Homepage, https://github.com/chrislee35/orange3-sqlquery
Keywords: orange3 add-on
Classifier: Development Status :: 3 - Alpha
Classifier: Intended Audience :: Education
Classifier: Intended Audience :: Science/Research
Classifier: Programming Language :: Python :: 3 :: Only
Requires-Python: >=3.11
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: numpy>=1.26
Requires-Dist: Orange3>=3.34.0
Requires-Dist: duckdb>=1.2.2
Requires-Dist: fast-json-normalize>=0.0.9
Requires-Dist: orjson>=3.11.3
Provides-Extra: test
Requires-Dist: coverage; extra == "test"
Provides-Extra: doc
Requires-Dist: sphinx; extra == "doc"
Requires-Dist: recommonmark; extra == "doc"
Requires-Dist: sphinx_rtd_theme; extra == "doc"
Dynamic: license-file

# 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](img/sqlquery-widgets-lineup.png)

#### DuckDB Table

![DuckDB Table Widget](img/duckdb-table.png)

#### JSON Loader

![JSON Loader Widget](img/json-loader.png)

#### JSON Lines Loader (and description)

![JSON Lines Loader Widget](img/json-lines-loader.png)

#### SQL Query Widget

![SQL Query Widget](img/sql-query-widget.png)

### 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.](img/sqlquery-example1.png?raw=true)

* [The Rainfall of Iranian Cities dataset](https://www.kaggle.com/datasets/mohammadrahdanmofrad/average-monthly-precipitation-of-iranian-cities)
* [Iranian City Locations](https://github.com/chrislee35/orange3-sqlquery/blob/main/datasets/iranian_city_locations.csv?raw=true)

