Comment by philefstat

yes you can add jobs with sql in a transaction, e.g.

SELECT graphile_worker.add_job( 'send_email', json_build_object( 'to', '[email protected]', 'subject', 'graphile-worker test' ) );

(can also use the PERFORM statement instead of SELECT)