Funnily enough earlier today I wrote "pg_dump ... -v" in a ticket, then went back and revised it to "pg_dump ... --verbose" for clarity.

Let's hope they allow abbreviations to speed things up, so rather than say:

"make directory foo and copy file.jpg to foo and convert file.jpg to file.png".

lazy people could type:

"mkdir foo && cp file.jpg foo/ && convert file.jpg file.png".

There was actually a CTE involved, as well as a lateral join.

Had to cheat a little and add a column and a trigger to keep it updated to keep the query practical, as the data structure wasn't quite suited for extracting what I wanted, but it saves updating the application and it's my own personal playground.

Quite, it was the visualizing of how the data would need to be queried which is the interesting part. Syntax is just typing.

(I mean this in a serious way, as most of my working days seem to be taken up with scripting DDL in the hope of triggering obscure corner-case bugs).

I think I had that one, or one very like it.

<Databases have entered the chat>