I think I'd like to just write a native SQL query (past basic tables and joins there's always some platform specific quirk or optimization) and have a better wa

I think I'd like to just write a native SQL query (past basic tables and joins there's always some platform specific quirk or optimization) and have a better way of mapping that to generic 'interfaces' (maps/dictionaries/whatever) or typed objects with members of specific types, and have the data correctly coerced to those types. The biggest pain point nearly always also seems to involve time conversions that might or might not use default assumptions and environment variables which language examples almost never cover. Toss in specifying an encoding to handle the result as (or to disable) and I think that's what might make up a good DB interface specification for drivers to implement.