CI is failing, because 'psycopg' is not installed

[doublebyte1]

Description

tests/provider/test_postgresql_provider is failing on the CI with this error:

pygeoapi/provider/sql.py:815: in __init__
    super().__init__(provider_def, driver_name, extra_conn_args)
pygeoapi/provider/sql.py:129: in __init__
    self._engine = get_engine(
pygeoapi/provider/sql.py:694: in get_engine
    engine = create_engine(
<sqlalchemy generated warned() wrapper for sqlalchemy.engine.create.create_engine>:2: in create_engine
    return target(fn, url, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^
/opt/hostedtoolcache/Python/3.12.14/x64/lib/python3.12/site-packages/sqlalchemy/util/deprecations.py:281: in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^
/opt/hostedtoolcache/Python/3.12.14/x64/lib/python3.12/site-packages/sqlalchemy/engine/create.py:602: in create_engine
    dbapi = dbapi_meth(**dbapi_args)
            ^^^^^^^^^^^^^^^^^^^^^^^^
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 

cls = <class 'sqlalchemy.dialects.postgresql.psycopg.PGDialect_psycopg'>

    @classmethod
    def import_dbapi(cls):
>       import psycopg
E       ModuleNotFoundError: No module named 'psycopg'

Steps to Reproduce
Run the build task on the CI and watch for the provider tests.

Expected behavior
CI is expected to execute the tests, using the dependencies that were installed through the requiremens-provider.txt.