Use squish for raw SQL query RB-E1003
Anti-pattern
Major
When explicitly specifying a SQL query in a method such as find_by_sql, use heredocs with the squish method. This allows
you to legibly format the SQL with line breaks and indentations, while supporting syntax highlighting in many tools
(including GitHub, Atom, and RubyMine).
Bad practice
<<-SQL
SELECT * FROM posts;
SQL
<<-SQL
SELECT * FROM posts
WHERE id = 1
SQL
execute(<<~SQL, "Post Load")
SELECT * FROM posts
WHERE post_id = 1
SQL
Recommended
<<-SQL.squish
SELECT * FROM posts;
SQL
<<~SQL.squish
SELECT * FROM table
WHERE id = 1
SQL
execute(<<~SQL.squish, "Post Load")
SELECT * FROM posts
WHERE post_id = 1
SQL