Feature: Add syntax highlighting for table name completion

[prrao87]

API

Other

Description

Say we have this list of tables:

┌────────┬─────────────────────────┬───────────┬───────────────┬─────────┐
│ id     │ name                    │ type      │ database name │ comment │
│ UINT64 │ STRING                  │ STRING    │ STRING        │ STRING  │
├────────┼─────────────────────────┼───────────┼───────────────┼─────────┤
│ 1      │ Person                  │ NODE      │ local(kuzu)   │         │
│ 4      │ MENTIONS_Chunk_Location │ REL       │ local(kuzu)   │         │
│ 2      │ Location                │ NODE      │ local(kuzu)   │         │
│ 0      │ Chunk                   │ NODE      │ local(kuzu)   │         │
│ 9      │ HAS_HEADQUARTERS_IN     │ REL       │ local(kuzu)   │         │
│ 6      │ MENTIONS_Chunk_Person   │ REL       │ local(kuzu)   │         │
│ 7      │ MENTIONS                │ REL_GROUP │ local(kuzu)   │         │
│ 3      │ Company                 │ NODE      │ local(kuzu)   │         │
│ 8      │ IS_CEO_OF               │ REL       │ local(kuzu)   │         │
│ 5      │ MENTIONS_Chunk_Company  │ REL       │ local(kuzu)   │         │
│ 10     │ IS_COO_OF               │ REL       │ local(kuzu)   │         │
└────────┴─────────────────────────┴───────────┴───────────────┴─────────┘

It would be a great convenience feature to have the CLI auto-complete table naming. For e.g., if I know there's a Location node table, I'd want the CLI to help me autocomplete the it as I type the following query:

kuzu> MATCH (n:Lo

I'd type Lo and press tab and the full table name Location would appear based on the most similar name in the list of available tables in my database. DuckDB provides such a feature in its CLI.