Is there any way to extract my prisma queries and transform them into postgres functions?

Not at the moment. You would need to manually fetch them from the logs and then create functions for those.

how can i inspect the logs? adding

log: ['query', 'info', 'warn', 'error'],

to my prismaclient doesn't show me the insert statements that were executed

It will show all statements including

insert

in the console. Only

query

is needed to see the logs.