AFAIK, SQL Server's Hekaton engine only compiles the queries inside of stored procedures and UDFs. They do not compile every query that comes in from the client:

https://docs.microsoft.com/en-us/sql/relational-databases/in...