Add limit clause support and associated test.