undefined | Better HN

0 pointsXeoncross3y ago0 comments

ORM's help do simple stuff well enough, but they sure make hard tasks harder. Ever try to construct a 30 line report query using this years language flavor of an ORM?

https://sqlc.dev/ makes your SQL the focus, not your Go-specific query code.

0 comments

smw3y ago

Lots of ORMS have an escape to SQL for querying, or you can choose to ignore the ORM for querying. As an example, ActiveRecord allows you to do this:

  Client.find_by_sql("
  SELECT * FROM clients
  INNER JOIN orders ON clients.id = orders.client_id
  ORDER BY clients.created_at desc
  ")

Which returns Client objects. Insert your own vastly more complex query above.

j / k navigate · click thread line to collapse

0 comments

smw3y ago

Lots of ORMS have an escape to SQL for querying, or you can choose to ignore the ORM for querying. As an example, ActiveRecord allows you to do this:

  Client.find_by_sql("
  SELECT * FROM clients
  INNER JOIN orders ON clients.id = orders.client_id
  ORDER BY clients.created_at desc
  ")

Which returns Client objects. Insert your own vastly more complex query above.

j / k navigate · click thread line to collapse