I think the examples here are pretty good: https://boringsql.com/posts/beyond-start-end-columns/