When you work with RDBMS you have views and tables which relate to each other.
i would like to build sql query in Query Filter which reads not only current layer properties but reads even other tables or views like you can do in QGis.
For example in Autocad map you can query only based on the current layer properties:
Meanwhile in QGis you can query through all layers and vew properties:
