New best story on Hacker News: Ask HN: How do you test SQL?

Ask HN: How do you test SQL?
585 by pcarolan | 280 comments on Hacker News.
I've been looking for resources for our data team to apply best practices for testing SQL pipelines (we use DBT) but have not found anything. How do you test SQL pipelines? What patterns, tools and best practices would you recommend? Any good reference material you know of?