I ran into a major roadblock when using sqlc by not being able to parametrize ORDER BY values. Seems to be a lot of cases of this kind of problem where you can't just fit what you want to do into a parameters and then you are stuck with writing two (or more) very similar queries.

I pretty much given up on tab-complete, only complete questions to get niche knowledge. Usually around what sort of magical incantations I need to accomplish a task using a certain API/tool.

80% of the time the output is not correct, but at least points me to the right direction.

I once managed to catch a capybara breastfeeding their babies

Man when I thought I was getting to understand linux firewalls using iptables, BAM now you are supposed to use nftables.