How do I auto-comple Foreign Key?

Note: I am both new to SQLite and litecli, so maybe I just didn't find the right documentation.

I have two tables, `cards` and `card_types`. In my table `cards` I have an entry called `type`, which uses a [FOREIGN KEY](https://sqlite.org/foreignkeys.html): `FOREIGN KEY("type") REFERENCES "card_types"("type")`. Now whenever I insert something into `cards` I want to simply auto-complete my `type` from `card_types`:

- For example with an entry `"special"` in `card_types`, I expected to be able to `INSERT INTO cards (name, type, effect) VALUES ("Pocketsand", spec` and have it autocomplete to `"special"`.
- Same when using a "Favourite Query" (which are awesome, btw): `new_card | INSERT INTO cards (name, type, effect) VALUES ("$1", $2, "$3")` > `new_card "Pocketsand" spec`

Am I doing something wrong? Or is this simply not possible? (If not, then this would be a pretty nice feature)

Commencez par examiner le comportement actuel de l’autocomplétion de litecli et la documentation SQLite liée sur les clés étrangères. Vérifiez comment les instructions INSERT et Favourite Queries sont traitées, puis vérifiez qu’une valeur de clé étrangère telle que "spec" peut être complétée par la valeur correspondante de card_types dans les deux exemples.

Rédigé par le modèle d'indexation à partir du texte de l'issue.