If you ever needed to add an SQL function that you can use in your Elixir project you might have skipped writing tests for it. There are a couple of official ways1 2 you can write unit tests for PostgreSQL functions but having it in the same code base will make it so you actually maintain the tests.

https://0x7f.dev/post/unit_testing_sql_functions/