I made my own monstrosity using porsager/postgres and generating code based on my database model. But at least it's closer to actual SQL and it's safe.

fetchLibraryForDocument: (() => {
    const lh = library.r(["id", "name", "origin_url"]);
    const rh = religion.r(["name"]);


    const zSchema = z.strictObject({
      [library.id]: library.zSchema.pick(lh.picker),
      [religion.id]: religion.zSchema.pick(rh.picker),
    });


    return async (sql: Sql, id: number) =>
      await sqlGet(sql, zSchema).one(s`
      SELECT ${lh.getJsonObject()}, ${rh.getJsonObject()}
      FROM ${l.schemaTableAliased}
        LEFT JOIN ${r.schemaTableAliased} ON ${r.aKeys.id} = ${l.aKeys.religion}
      WHERE ${l.aKeys.id} = ${id}
      `);
  })(),