Looking at my LabKey debug log, a query based on a table, i.e., a LabKey.ext.Store configured via a 'queryName' uses:

  QueryServiceImpl.getSelectSQL(FilteredTable over lab.expectations_change_log)

Whereas, a query based on dynamic SQL, i.e., a LabKey.ext.Store configured via a 'sql' string uses:

  QueryServiceImpl.getSelectSQL(org.labkey.query.sql.QuerySelect$1@5d453015)

The filtering behavior seems to be centered in the FilteredTable class.

So my reading of this is that EditableGrids configured to use a LabKey.ext.Store configured with a 'sql' query string are not designed to support filtering via a column filter set via the Grid's UI.