New cacherecorder+API middleware services, SQL query gen fixes

Updated SQL parameter ordinal injection to account for growing offset (multiple ordinals in the same clause would render incorrectly). Added join type override to allow for left or inner joins.

Imported and improved API middleware service into core lib. Will allow either retrieval of full set of results or single page with passthrough of pagination attributes for link header generation. Added Flat (non-aware) request wrapper for when calls are made outside of request context and context cannot be properly initialized.

Updated pagination default max to 100 to better accommodate batch fetching.

Increment to 0.6.1 release.