KB10255 - Can I select a shape based on a query to the external database?

Yes. Select a query in the external database and apply the join. The coverage will be limited to the shapes matching the query.