The point of the simple example was to counter the statement that code would inherently become complex and unreadable if you had to track and check if the initial "WHERE 1=1" needed to be removed ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

SQL databases such as MySQL and PostgreSQL are really good at performing complex joins, filtering, and sorting in order to get exactly the data you need out of a query and nothing more.