Apologies if this question has been answered elsewhere: I’ve had no luck when searching. I’m also a SQL newbie, so I hope the answer to my question isn’t too elementary.

What am I doing wrong here? I tried to follow the example provided in the docs, but run into the error that the table does not exists.
I am using a sqlite-db for testing.

Can I make a relationship with table C, which contains a foreign key to table B, which contains a foreign key to table A, from C to A? Something like the following:

i’m using htmx and sqlmodel to filter and return data via fastapi.