### 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)

hql = (
            "set key;\n"
            "set airflow.ctx.dag_id;\nset airflow.ctx.dag_run_id;\n"
            "set airflow.ctx.task_id;\nset airflow.ctx.execution_date;\n"
        )
        dag_id_ctx_var_name = AIRFLOW_VAR_NAME_FORMAT_MAPPING["AIRFLOW_CONTEXT_DAG_ID"]["env_var_format"]
        task_id_ctx_var_name = AIRFLOW_VAR_NAME_FORMAT_MAPPING["AIRFLOW_CONTEXT_TASK_ID"]["env_var_format"]
        execution_date_ctx_var_name = AIRFLOW_VAR_NAME_FORMAT_MAPPING["AIRFLOW_CONTEXT_EXECUTION_DATE"][
            "env_var_format"
        ]
        dag_run_id_ctx_var_name = AIRFLOW_VAR_NAME_FORMAT_MAPPING["AIRFLOW_CONTEXT_DAG_RUN_ID"][
            "env_var_format"
        ]
        mock_output = [
            "Connecting to jdbc:hive2://localhost:10000/default",
            "log4j:WARN No appenders could be found for logger (org.apache.hive.jdbc.Utils).",
            "log4j:WARN Please initialize the log4j system properly.",
            "log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.",
            "Connected to: Apache Hive (version 1.2.1.2.3.2.0-2950)",
            "Driver: Hive JDBC (version 1.2.1.spark2)",
            "Transaction isolation: TRANSACTION_REPEATABLE_READ",
            "0: jdbc:hive2://localhost:10000/default> USE default;",
            "No rows affected (0.37 seconds)",
            "0: jdbc:hive2://localhost:10000/default> set key;",
            "+------------+--+",
            "|    set     |",
            "+------------+--+",
            "| key=value  |",