but the standard idea would be to make the path-to-solution explicit, verifiable ("also tell us how you got to that"). In other terms, "avoid the black box". Maybe have the generated SQL query output... But this will not impede abuse from lazy users, and errors "may have consequences".

Databases (just think of the testing infrastructure for SQLite) are made to be fully reliable; if the interface were not so, you would have broken the model.