SQL dump does not support repeatable pointers
When exporting some databases (namely, the ones coming from Heurist), you can encounter this error:
File "~/.pyenv/versions/3.11.9/lib/python3.11/site-packages/heimdall/connectors/sql_dump.py", line 103, in _create_table
raise ValueError(f"Repeatable pointers not supported ({fault})")
ValueError: Repeatable pointers not supported (1627-111.1627-111.1627-1142)
This is because untyped/multiple pointers are not supported in SQL. This would mean a FOREIGN KEY could point to different tables, but AFAIK this is unsupported.
There are many ways to change the underlying database schema to support, for example the ones listed in this post : https://stackoverflow.com/a/7844911
heimdall.connectors.sql_dump module could make a choice between this, but this would mean forcing silent schema changes during the dump, and what would be read afterwards would be vastly different that was you had before.
Honestly, I'm not sure I'd like a connector doing this, especially one that is included in pyHeimdall proper.
However, what I like is for pyHeimdall to have schema upgrading utility methods, like the existing heimdall.util.refactor_relationship.
Users can thus upgrade their schema on their own accord between importing and exporting their database, opposed to a connector making choices (even configurable ones) for them.