misc(fix): do not apply limits to metadata queries

[sherali42]

Pull Request checklist

• [x] The commit(s) message(s) follows the contribution guidelines ?

reverting behavior, so that we do not apply limits on MetadataRemoteExec. Limits still get applied at leaf level