support for pagination (#24)

* support for pagination

* AppVeyor error fixes

* fixed logic error

* oops reverted last checkin

* support for foreign key references to derived type

* When paginating queries involving joins over multiple tables, just paginate main table