As others have mentioned, SQLite has fairly comprehensive support for JSON. Arrays can be represented as JSON arrays.
Some geometry features are supported through the R*Tree module: https://www.sqlite.org/rtree.html
And I'm not sure what sort of support you'd expect for a UUID type. Depending on how you represent the UUID, it's either a string or a blob -- I can't think of any meaningful operations to perform on a UUID which go beyond basic comparisons.
As others have mentioned, SQLite has fairly comprehensive support for JSON. Arrays can be represented as JSON arrays.
Some geometry features are supported through the R*Tree module: https://www.sqlite.org/rtree.html
And I'm not sure what sort of support you'd expect for a UUID type. Depending on how you represent the UUID, it's either a string or a blob -- I can't think of any meaningful operations to perform on a UUID which go beyond basic comparisons.