Pydantic dataclasses causes problems with sqlalchemy classic mappers

[sandys]

# from dataclasses import field
from pydantic.dataclasses import dataclass
from typing import List
from datetime import datetime
from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String, ARRAY, TIMESTAMP
from sqlalchemy.orm import sessionmaker, mapper

metadata = MetaData()
person_table = \
    Table('people', metadata,
          Column('id', Integer, primary_key=True, autoincrement=True),
          Column('name', String(255)),
          Column('age', Integer),
          Column('hobbies', String),
          Column('birthday', TIMESTAMP)
          )

@dataclass
class Person:
    id: int = None
    name: str = ''
    age: int = 0
    hobbies: str = None
    birthday: datetime = None

mapper(Person, person_table)

engine = create_engine("sqlite:///", echo=True)
metadata.create_all(engine)

session = sessionmaker(bind=engine)()
person = Person(id=None, name='Robby', age=33, hobbies="golf", birthday=datetime(1985, 7, 25))
session.add(person)
session.commit()

this works if i replace pydantic dataclasses with standard python dataclasses.

how can this be fixed ?

[sandys]

im closing this myself, since i saw #1089 and understand that this is a known WONTFIX issue