Metadata-Version: 2.4
Name: orange3-sqlquery
Version: 0.0.3
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: orange-canvas-core>=0.1.28
Requires-Dist: orange-widget-base>=4.20.0
Requires-Dist: duckdb>=1.2.2
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 users to perform SQL queries on multiple input tables.

## Installation

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

## Example Usage

![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.](https://github.com/chrislee35/orange3-sqlquery/blob/main/img/sqlquery-example1.png?raw=true)

### Example Datasets

* [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)

