Having written assorted data layers: If you can't replace a generated query with a chunk of literal SQL when optimisation or raw power indicates it's the best o

Having written assorted data layers: If you can't replace a generated query with a chunk of literal SQL when optimisation or raw power indicates it's the best option, the data layer sucks. Sadly, being software, "the data layer sucks" is true of most data layers.