Postgres functions
Hey, I'm migrating a ton of postgres raw sql into using drizzle ORM. Is there any sort of setup for migrating sql functions? I have a couple dozen sql functions to convert. Didn't see anything in the docs but thought i'd ask
1 Reply
Maybe you can try to create an 'empty migration' file to add your functions in the migration flow:
drizzle-kit generate:pg --custom (https://orm.drizzle.team/kit-docs/commands)
I don't think there is something to tell Drizzle about functions right now.
You can still invoke it in your queries with sql template: https://orm.drizzle.team/docs/sql#sql-templateList of commands – DrizzleORM
Drizzle ORM | %s
Magical sql operator 🪄 – DrizzleORM
Drizzle ORM | %s