I want both. An imperative language makes it more able to be isomorphic to a web app api. You can have corresponding types and functions without something totally different.

Optimizer hints is a good idea. As far as I know this isn't a well known feature (if it even is a feature) for postgresql, which is the DB I have the most experience with.