yeah, you can do stuff like <code>Table.select().max("some_column")</code>, but you can't build anything much more complex than that. the specific query that triggered my figuring out how to bypass SQLObject was one like "<code>SELECT n.id,count(k.id) as count FROM ... GROUP BY n.id ORDER BY count DESC LIMIT 5</code>" but it's also come in useful when i wanted to take advantage of some of postgresql's date formatting methods or access a database that uses stored procedures. in general, it just gives me a warm fuzzy feeling to know that as a last resort, i can always drop back to plain old SQL.
anders pearson - 2005-04-19 08:22:58
yeah, you can do stuff like <code>Table.select().max("some_column")</code>, but you can't build anything much more complex than that. the specific query that triggered my figuring out how to bypass SQLObject was one like "<code>SELECT n.id,count(k.id) as count FROM ... GROUP BY n.id ORDER BY count DESC LIMIT 5</code>" but it's also come in useful when i wanted to take advantage of some of postgresql's date formatting methods or access a database that uses stored procedures. in general, it just gives me a warm fuzzy feeling to know that as a last resort, i can always drop back to plain old SQL.