> where you can at least write a test and assert it's doing the right thing

SQL is code. PL/pgSQL is code. Code can be tested. Code should be tested. You don't even need to leave the database to write tests for SQL or PL/pgSQL[1].

[1] https://pgtap.org/