Remove idiotic RowCountOrGenericSubQ - it will never work as part of as_query

I am not sure how I overlooked this, blame is on me :(

Replacing with a ROWCOUNT fallback at the appropriate place
Start running more limit dialect torture tests if possible
Overhaul GenericSubq limit - add support for multicol order

A lot of other cleanup as well - this should be the end of it ;)