Couldn't the abstracted query layer... be SQL? You don't need to speak it to the server; you can parse it at the client-library level and send whatever optimized thing the server likes to it.