Definition Queries (Layer Filters)
Filter your layers without writing SQL: build filters with drop-downs, save several named filters per layer and switch between them in one click.
Filter your layers without writing SQL: build the query with drop-downs (field, operator and the layer's real values, including null and empty values, checkbox lists, AND / OR and groups) and the plugin writes the SQL for you. The operators are those of ArcGIS: is (not) equal to, is one of, contains, (does not) start or end with, is (not) between, is on / before / after for dates, and more. Save several named filters per layer inside the project and switch between them from the layer's right-click menu. Use any query as a filter or as a selection, select the features visible in the map view, create a filter from the current selection, and check how many features match before applying it. Warnings catch common mistakes (misspelled values, ambiguous numbers such as 1.000, AND and OR mixed without a group, filters that keep nothing, fields that were renamed). The SQL is written for each format (GeoPackage, Shapefile, GeoJSON, FileGDB, PostGIS, CSV and more), so accents, upper/lower case, underscores, percent signs and dates filter the same everywhere. Syncs with QGIS 'Filter...' and includes Processing tools. Interface in English, Spanish and Portuguese (follows the QGIS language).