### Description

#27647 has introduced filtering for invalid schemas in Hive hook based on the characters `;` and `!`. I'm wondering if a more generic filtering could be introduced, e.g. one that adheres to the regex `[^a-z0-9_]`, since Hive schemas (and table names) can only contain alphanumeric characters and the character `_`.

Note: since the Hive metastore [stores schemas and tables in lowercase](https://stackoverflow.com/questions/57181316/how-to-keep-column-names-in-camel-case-in-hive/57183048#57183048), checking against `[^a-z0-9_]` is probably better than `[^a-zA-Z0-9_]`.

### Use case/motivation

Ensure that Hive schemas used in `apache-airflow-providers-apache-hive` hooks contain no invalid characters.

### Related issues

_No response_

### Are you willing to submit a PR?

- [X] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)

"+------------+--+",
            "1 row selected (0.133 seconds)",
            "0: jdbc:hive2://localhost:10000/default> set airflow.ctx.dag_id;",
            "+---------------------------------+--+",
            "|               set               |",
            "+---------------------------------+--+",
            "| airflow.ctx.dag_id=test_dag_id  |",
            "+---------------------------------+--+",
            "1 row selected (0.008 seconds)",
            "0: jdbc:hive2://localhost:10000/default> set airflow.ctx.dag_run_id;",
            "+-----------------------------------------+--+",
            "|                   set                   |",
            "+-----------------------------------------+--+",
            "| airflow.ctx.dag_run_id=test_dag_run_id  |",
            "+-----------------------------------------+--+",
            "1 row selected (0.007 seconds)",
            "0: jdbc:hive2://localhost:10000/default> set airflow.ctx.task_id;",
            "+-----------------------------------+--+",
            "|                set                |",
            "+-----------------------------------+--+",
            "| airflow.ctx.task_id=test_task_id  |",
            "+-----------------------------------+--+",
            "1 row selected (0.009 seconds)",
            "0: jdbc:hive2://localhost:10000/default> set airflow.ctx.execution_date;",
            "+-------------------------------------------------+--+",
            "|                       set                       |",
            "+-------------------------------------------------+--+",
            "| airflow.ctx.execution_date=test_execution_date  |",
            "+-------------------------------------------------+--+",
            "1 row selected (0.006 seconds)",