SQLite Forum

SQLite3 Array?
Login
I know that. But as the OP wasn't very clear, I extrapolated a little.

> SQLite does not have an ARRAY type

Well, there's [JSON1][1], `json_each()` and `json_group_array` allow  
to *take-apart* and *reconstitute* JSON arrays, so that close :).

The Sudoku solver also uses the string as an array of sort too.

So you're of course right that SQLite doesn't have arrays per-se,  
but *packing* several values in strings is a common work-around.  
That likely complicates calculating a shortest-path in SQL, but  
it is still probably possible.

[1]: https://www.sqlite.org/json1.html