[mysql] Unable to Grant permissions on specific columns in table

[ymaniukevich]

What problem are you facing?

There is no way to grant permissions on specific columns. For example, the following privilege SELECT (id, email) is not supported by regexp (^[A-Z_ ]+$):

How could Crossplane help solve your problem?

We need to enhance the regular expression (regexp) logic so that it can effectively allow granting permissions on specific columns, like in the query example, while also blocking potential SQL injection.

Let me know if this is relevant, I can submit a PR