> Further, we want to spare the dev-experience of using WHERE clauses

A laudable goal, but one which is easily solved at library level, or at the "infrastructure code" level. I've been doing this across a range of databases for several years.