> Try to avoid the bespoke features of psql in favor of generic SQL unless cornered by circumstances into doing so, methinks.

Why? To make migration to another database easier? I've never had the need to migrate any application away from postgres. I usually take full advantage of what the database can do.