> The language appropriate tool for writing SQL is SQL. Anything else is a mess... It sounds like you're pretty set on that opinion, and that's fine, but I sus

> The language appropriate tool for writing SQL is SQL. Anything else is a mess... It sounds like you're pretty set on that opinion, and that's fine, but I suspect you just haven't run into the case where the raw SQL is far messier than using a query builder. SQL strings are pretty inflexible. The big advantage of a query builder (note that I'm not saying "ORM") is that you can start with a simple base case and dynamically mutate the query to add clauses specific to the request you're handling. Maybe one user wants 10 results per page and another user wants 25, for example. I have an example of how far you can take this at http://btubbs.com/postgres-search-with-facets-and-location-awareness.html http://btubbs.com/postgres-search-with-facets-and-location-a.... I could not endorse trying to build the query interface in that post with raw SQL.