### Apache Airflow version

2.5.3

### What happened

When I call the airflow initdb function, it outputs these lines to the log

INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.

### What you think should happen instead

There should be a mechanism to disable these logs, or they should just be set to WARN by default

### How to reproduce

Set up a new postgres connection and call:

from airflow.utils.db import initdb
initdb()

### Operating System

MacOS

### Versions of Apache Airflow Providers

_No response_

### Deployment

Virtualenv installation

### Deployment details

_No response_

### Anything else

_No response_

### Are you willing to submit 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)

with create_global_lock(session=session, lock=DBLocks.MIGRATIONS):
        if show_sql_only:
            log.warning("Generating sql scripts for manual migration.")
            if not from_revision:
                from_revision = _get_current_revision(session)
            revision_range = f"{from_revision}:{to_revision}"
            _offline_migration(command.downgrade, config=config, revision=revision_range)
        else:
            log.info("Applying downgrade migrations.")
            command.downgrade(config, revision=to_revision, sql=show_sql_only)
def drop_airflow_models(connection):
    """
    Drops all airflow models.
    :param connection: SQLAlchemy Connection
    :return: None
    """
    from airflow.models.base import Base
    
    
    chart = Table("chart", Base.metadata)
    chart.drop(settings.engine, checkfirst=True)
    user = Table("user", Base.metadata)
    user.drop(settings.engine, checkfirst=True)
    users = Table("users", Base.metadata)
    users.drop(settings.engine, checkfirst=True)
    dag_stats = Table("dag_stats", Base.metadata)
    dag_stats.drop(settings.engine, checkfirst=True)
    session = Table("session", Base.metadata)
    session.drop(settings.engine, checkfirst=True)
    Base.metadata.drop_all(connection)