Enable In-Memory OLTP for SQL Azure Standard tier
Upgrade Azure SQL Database in Standard tier from 12.0.2000.8 to 14.0.1000.169 and enable memory-optimized tables and natively compiled stored procedures.
I hope this has always been planned to roll out in-memory OLTP for lower tiers and was started at the higher tiers to work out the technicalities. Otherwise it kind of defeats the purpose of what cloud is touted for, i.e. the ability to start small and scale up as needed. By offering In-Memory OLTP only on the upper tiers it doesn't give the same advantages to the smaller guys who don't have the big budgets. We're running standard and the price jump to premium or vcores would be an unjustifiable gross overallocation of resources for our needs just to get In-Memory OLTP. So because of that our caching and temp tables are consuming a vast amount of unnecessary DTUs. Either way we're wasting money. Cloud should be helping the little guys so they can become big guys.
If as the OP says the difference is because of version number of sql server, and it's easier to make a new Standard v2 tier to be able to phase out the older sql, that would work for us at this time, we'd take the time to convert.
Mehdi Kharab commented
Indeed, the price to move from general purpose (elastic pool) to Crititical purpose is too expensive for us to achieve OLTP. It will be great if this feature is available starting from General prupose (example : prerequisite is to have at leat 10 vcores)