Where clause can now be specified in Export Dataset when exporting a list of tables/views.
See Automation Designer -> Export Dataset -> Dataset Tab -> List of DB Objects.
To add/edit, right-click in the tree or double-click in the "Where" clause column.