SA Warning #295
Description
@Boyuan-Deng is getting this warning when running examples client-side:
util.warn(
/home/boyuan/anaconda3/envs/py39/lib/python3.9/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'Label.labels' will copy column io_pointers.value to column labels_io_pointers.io_pointer_value, which conflicts with relationship(s): 'IOPointer.io_pointers' (copies io_pointers.value to labels_io_pointers.io_pointer_value), 'Label.io_pointers' (copies io_pointers.value to labels_io_pointers.io_pointer_value). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. The 'overlaps' parameter may be used to remove this warning.