[WuxiFingerHold]

I'm not a fan of "just in case" development. Not when it comes to interfaces and also not regarding this `where 1=1` placeholder. Do things when you need them. Not if you think you might need them someday in the futures. Also, production code is not the place to keep dev helpers around. Do what you want in dev time, but for prod code readability and clear intent is much more important.

[password4321]

Do you fully qualify all table + column name references? I've found it often increases readability by at least an order of magnitude but quickly becomes very verbose and incredibly painfully tedious to write.

[knighthack]

With autocomplete (like with Jetbrain's Datagrip) I found that verbose table names aren't that much of a problem; they in fact really help readability.

[password4321]

Maybe fully qualifying all entity references is table stakes these days, I'll have to give Datagrip a spin.

I already complained about autocomplete in response to another comment asking to put FROM first; maybe existing tooling is enough to make my life easier.