There are a lot of transpilers, and they don't get much adoption because the people implementing them are not the people implementing the database. The databas

There are a lot of transpilers, and they don't get much adoption because the people implementing them are not the people implementing the database. The database and the query language are tightly coupled. The latter determines the kinds of optimizations that the former can do, and a transpiled language means that optimization info needs to be passed through in weird and inefficient ways; it also means that obvious optimizations aren't possible, because the people building the language are not building the db. If you've ever tried used query hints, or deeply inspected a distributed query plan, you'll know exactly what I mean.