[QGIS-Developer] Execute SQL tool

[Vedran Stojnović]

Hi Raymond and Alessandro,

I would just like to add that I miss multiple SQL statements/SQL script
execution in current implementation, and I've already created a feature
request on this topic in GDAL/OGR:
https://github.com/OSGeo/gdal/issues/11279

I think that these proposals are super useful features and I think that
this is a good topic for QEP or for independent funding campain.

pet, 17. lis 2025. u 10:09 Alessandro Pasotti via QGIS-Developer <
qgis-developer at lists.osgeo.org> napisao je:

> Hi Raymond,
>
> The long-term goal is still to replace the python implementation of DB
> manager with a C++ core implementation accessible from the browser, we are
> not there yet but significant steps in that direction have been made.
>
> Regarding your issues, I think the first step is to add your
> enhancement/bugfixing requests and specify when they are related to a
> specific provider (GPKG -> OGR).
>
> Please note that in the filtered list of existing issues there are a few
> unrelated ones (there is a processing algorithm with a similar name).
>
> Kind regards.
>
>
>
> On Thu, Oct 16, 2025 at 1:22 PM Raymond Nijssen via QGIS-Developer <
> qgis-developer at lists.osgeo.org> wrote:
>
>> Dear devs,
>>
>> Lately I've been working with the Execute SQL tool on gpkg database
>> files, cause I'm trying to switch from the DB Manager to the QGIS native
>> tool. I was told the DB Manager is going to be deprecated in the near
>> future. Is that the goal?
>> I'm wondering if other people are using the 'Execute SQL' tool as well,
>> as I'm not really satisfied with the current functionality and I cannot
>> find any complains in the mailing list or github issues.
>>
>> Some problems I encounter:
>> * The result table is (randomly?) not showing the FID or other PK
>> columns, nor the geometry column. But those are often important while
>> writing SQL queries.
>> * Loading the QueryLayer always creates a multigeometry layer not
>> showing anything on the map. (Btw I think QGIS should be able to render
>> multigeometries, or at least to set a 'point', 'line' or 'polygon' style
>> to the multigeometry layer to force it rendering that type.)
>> * The cursor somehow jumps randomly to other lines when (re)focusing on
>> the SQL S
>> * The clear button works *very* well, when you accidentally press it you
>> loose the entire query without warning and ctrl-Z won't bring it back.
>> * The error widget is large and leaving only a few lines of the SQL
>> editor to find an fix my error. The splitter between them does not show
>> the handle for resizing the widgets.
>>
>> If developers are interested in fixing this, please let me know. I'm
>> happy to help and test and I can also try finding some funding for this.
>>
>> For me, a more productive SQL tool in QGIS would be:
>> * In a dockable panel
>> * Connected to one or more layers that update every time I execute my
>> SQL (like the map in DBeaver)
>>
>> QGIS could be the best geo SQL editor in the world!
>>
>> There are current issues:
>>
>> https://github.com/qgis/QGIS/issues?q=is%3Aissue%20state%3Aopen%20%27execute%20sql%27
>>
>> Should I add all mine?
>>
>> Kind regards,
>> Raymond
>> _______________________________________________
>> QGIS-Developer mailing list
>> QGIS-Developer at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>
>
> --
> Alessandro Pasotti
> QCooperative:  www.qcooperative.net
> ItOpen:   www.itopen.it
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>


-- 
Srdačan pozdrav / Kind regards,
Vedran Stojnović.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20251017/d8a2950e/attachment-0001.htm>