Allow Paths or generic geometry support to be used for annotations

[ahuang11]

I want to annotate a line on a map and have it persisted:

At the current moment, I believe there are "start"/"end" and "point" columns? I additionally propose a "geometry" column (if there isn't one yet, this seems to suggest there is partial support for it)?

Since I don't think SQLite natively supports geometry, I imagine the we could utilize to_wkt (well-known-text) to store the data as string type, and from_wkt to serialize back the geometry, like I did here for MapnStreets since Parquet also doesn't natively support geometry.

I am happy to help implement this if the plan is agreed on.