I am trying to convert SQL code to Seqel to run it from my script. How do I convert this:
select code, count(1) as total
from school_districts
group by code order by total desc;
into Sequel? Or, is there a way to pass raw SQL to Sequel? Also the school_districts
will be interpolated #{table_name}
.
You can do it a couple ways:
Use []
:
DB["your sql string"]
Use fetch
:
DB.fetch("your sql string")