I've been following https://github.com/adelsz/pgtyped https://github.com/adelsz/pgtyped for awhile. It should give you TS types from sql files (and even sql tem

I've been following https://github.com/adelsz/pgtyped https://github.com/adelsz/pgtyped for awhile. It should give you TS types from sql files (and even sql template literals) directly. Though I haven't used it in prod. Might be worth a look.