Have you had experience working with the SQLAlchemy Core library for database management?

SQLAlchemy Core is a low-level API for working with databases in Python, which allows building SQL queries programmatically without using ORM. It provides objects for describing tables, columns, and expressions, as well as executing queries directly.

Example of creating a table and inserting data using SQLAlchemy Core:

from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String

engine = create_engine('sqlite:///:memory:')
metadata = MetaData()

users = Table('users', metadata,
              Column('id', Integer, primary_key=True),
              Column('name', String),
              Column('age', Integer))

metadata.create_all(engine)

with engine.connect() as conn:
    insert_stmt = users.insert().values(name='Ivan', age=30)
    conn.execute(insert_stmt)
    result = conn.execute(users.select())
    for row in result:
        print(row)

This approach is useful when flexibility in building queries is needed without using ORM.