sqllite as inmmeory db for mssql

My setup is similar to this for testing dapper calls for mssql using in memory sqllite. http://ift.tt/294FQhV

Using this lib http://ift.tt/1dUGmJ2

I'm using dapper with ad hoc sql for my DAL and wanted to test data access layer without dependency on sql server. I used sqllite inmmeory db. Problem is sql sytanx are different between mssql and sqllite. For example I have a query that returns paged results using offset and fetch next , but sqllite only supports limit and offset. What if any suggestions you have for me to do my in memory unit test? I didn't go ef route with mocked db context as dapper is more performant and didn't want to use sproc as I wanted to test my sql as well. I'm not looking to mock my db calls.