How does HugSQL react to store procedure or trigger statement in the sql-file?
I've never tried that but I think the right place to create triggers or stored procedures are migrations.
e.g. there's migratus for raw SQL migrations