There is possibility to get SQL query on filter - it’s useful, but much more usable solution is invoke dialog on filter, to ask for desired parameters and generate xml dataset which is composed from all entities in datastructure, filtered by this parameters.
This xml dataset can be used for transformation debugging or report creation.