Not really a fan of SMEQL, but I do wonder why we don't have more specialist languages that can transpile to sql. It might be the case that that a better sql on

Not really a fan of SMEQL, but I do wonder why we don't have more specialist languages that can transpile to sql. It might be the case that that a better sql only offers minor improvements and work needs to be done elsewhere, like in the hydration back into non-2d data, the current solutions I've seen require multiple repetitive sql statements and we might be better off making the hydrators smarter.