> You can have functional SQL query languages that map directly to SQL without object oriented row mapping.

Well said. I always think of this as the canonical example:

http://sqlkorma.com/

I don't know what rock I've been under, but didn't realize SQLAlchemy had the same idea w/ SQLAlchemy Core.

Another excellent example of this is Elixir's Ecto library for composing SQL from modular fragments https://github.com/elixir-ecto/ecto/blob/master/README.md

> without object oriented row mapping

Korma seems to do exactly that, N+1 lazy loaded queries included. SQLAlchemy, Esqueleto, Slick, Quill, and the like all generate precisely what you tell them to (i.e. queries semantically the same as what you'd write by hand).

This is not to disparage Korma, it looks pretty cool, I'd certainly give it a look if I worked with Clojure.

Is that really a disclaimer, or just the source for your claim?

I'm sure you know this, but there are actually several "query builder" tools out there for Python, including SQLAlchemy Core. I'd love to see a side-by-side comparison.

He probably meant "disclosure", not "disclaimer".

The overlords of HN have deemed my post is too old for an "edit" button so, yes, my use of "disclaimer" is a case of auditory familiarity overruling accurate terminology

Sorry, it was just my half-assed attempt at flattery anyway ;)