SQL Database Mine

QGIS Plugin to mine related data from a SQL database server.

Designed as a plugin for QGIS version 3.40+ and is QGIS4 ready but yet to be tested. Works with QGIS 3.44 and Qt6.
Python 3.11+
Requires Python module "sqlalchemy". This should be installed from your operating system distribution.
All other required Python modules should already be installed for QGIS to be working database layers.
Supports Qt5 & Qt6

Mine data from selected features within a QGIS vector layer.
Related data derived from a layer's Relationships and Joins can then be searched by selecting the required relationship.
Once related data is searched, you can keep mining deeper with any further relationships.

Where a vector layer is stored within a SQL database, the search is executed on the SQL database server, utilising the database indexes for rapid responses.

If the related data has GIS features, these can be selected and zoomed into on the QGIS map. These features may not be visible if there are other layers overlaying.

Rows of selected data can be copied into the clipboard for use in other applications.

A query form is also included to enable SQL database searches and view the resulting features on the QGIS map.

The inbuilt QGIS features to view table data loads and scans the layers full data, which is unusable for large datasets.
SQL Database Mine performs the query on the database server and only deals with the resulting dataset.

The database username, as defined in the vector layer's data source, may require the "SHOW VIEW" privilege to be granted on the GIS database schema.

SQL Database Mine has mostly been tested against a MariaDB database.
Minimal testing has been performed using ODBC, SqlLite and Postgres.
Requires testing on MSSQL and newer versions of Oracle.