Hacker News Reader

I assume that framework is not open-source or somewhere I can look at it?

You could take a look at the open-source dbt framework. They have a good implementation of unit testing for sql

I guarantee you wouldn't want to use it