The first two things I would look into:
1. Check the sqlite install/version that SqlAlchemy uses. It is often NOT
the same as the basic operating system install invoked in your terminal.
Sometimes that version does not have the functionality you need.
2. Check the transactional isolation
*Is the relationship between Fact and Info meant to be many-to-many? And
likewise the relationship between Text and Info?*
You are right about that.
Your code did exactly what I wanted. Thank you so much!
I figured it could have to do somethin with a subquery but I'm just
starting
It's difficult to tell from your code what your intention is. Is the
relationship between Fact and Info meant to be many-to-many? And likewise
the relationship between Text and Info?
Forgetting SQLAlchemy for a moment, what is the SQL that you want to
produce?
Does the script below do what you