[Browser] Display only the tables created by the user in the spatialite db

[pigreco]

Feature description

With the upgrade of SpatiaLite from 4.3 to 5.1, the Browser Panel displays all the system tables of the SpatiaLite database instead of only displaying the tables created by the user.

If I created an empty database from the Browser Panel, I would display two system tables that it would be better not to display;

test_browser_spatialite_QGIS.zip

If you created an empty spatialite database with spatialite_gui, the browser would display many system tables and this is not functional:

test_browser_spatialite_gui.zip

Additional context

The ideal would be to view only the tables created by the user as happens in the view of the Connections starting from the Data Source Manager:

[elpaso]

You can't compare the two views: in the data source manager you have to check [ ] Mostra anche tabelle senza geometria

[pigreco]

@agiudiceandrea
what do you think about this

[agiudiceandrea]

@elpaso @pigreco, the Browser (like the DB Manager) doesn't have a dialog window where it is possible to select to show/hide geometryless tables and thus it is normal to always show geometryless tables except if they are system tables.

If "KNN" and "data_licenses" tables (and the other ones listed in the second screenshot) are considered system tables for SpatiaLite/SQLite, then they should be hidden.

@nirvn worked on this many years ago #5850.