get the database server information when doing connection

[sahasrara62]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

def get_database_version():

    with engine.connect() as connection:
        dialect = engine.dialect.name
        query_map = {
            "postgresql": "SHOW server_version",
            "mysql": "SELECT VERSION()",
            "sqlite": "SELECT sqlite_version()",
            "oracle": "SELECT banner FROM v$version",
            "mssql": "SELECT @@VERSION"
        }
        
        if dialect not in query_map:
            raise ValueError(f"Unsupported database dialect: {dialect}")
        
        result = connection.execute(text(query_map[dialect]))
        return result.scalar()

Description

when i connect with the database server, i want to know the information about it ie it's metadata, like server name, version etc.
with current case, what i can do is

def get_database_version():

    with engine.connect() as connection:
        dialect = engine.dialect.name
        query_map = {
            "postgresql": "SHOW server_version",
            "mysql": "SELECT VERSION()",
            "sqlite": "SELECT sqlite_version()",
            "oracle": "SELECT banner FROM v$version",
            "mssql": "SELECT @@VERSION"
        }
        
        if dialect not in query_map:
            raise ValueError(f"Unsupported database dialect: {dialect}")
        
        result = connection.execute(text(query_map[dialect]))
        return result.scalar()

but this is external code i have to write to get information, can't we do this thing nativetly, where when engine is connected we get this information and attached this meta data to engine object or other place.

In django we have this functionality, where using connection.get_database_version() we got the information about it. but here we need to go through this way.

it might be a good feature to add this information to engine object when a connection happen

Operating System

Linux, Windows, macOS

Operating System Details

No response

SQLModel Version

0.0.24

Python Version

3.11

Additional Context

No response