Basic SQL sure, but the moment you start getting into complex operations, upserts, extensions, functions, custom aggregate operators, arrays, HStores, etc it gets complicated. At least for me.

I would not be able to do this super quickly: https://stackoverflow.com/a/42939280