The solution is to use SQL views, materialized views, or create a new table that contains only the filtered data the user needs.

Just use SQL views instead of select statements and then treat the views the same as tables, and we’re done. Views have more limitations than select statements, but for most use cases, they’ll ...

As the other posts have said, mySQL has historically been missing some RBDMS features that many serious DBAs consider critical. Triggers, stored procedures, views, foreign keys, etc.