fix: Add timestamp type (#10202)

erezrokah · web-flow · commit 5bbf8ddc0a25 · 2023-04-19T16:58:59.000Z
#### Summary Related to koltyakov/cq-source-sharepoint#19 (comment). SQLite doesn't have an official `timestamp` type but the Go lib takes care of it, see mattn/go-sqlite3#748. We had this type in `v1`, see https://github.com/cloudquery/cloudquery/blob/plugins-destination-sqlite-v1.3.6/plugins/destination/sqlite/client/types.go#L58 <!--
diff --git a/plugins/destination/sqlite/client/types.go b/plugins/destination/sqlite/client/types.go
@@ -16,6 +16,8 @@ func (*Client) arrowTypeToSqliteStr(t arrow.DataType) string {
 		return "real"
 	case arrow.BOOL:
 		return "boolean"
+	case arrow.TIMESTAMP:
+		return "timestamp"
 	default:
 		return "text"
 	}
@@ -33,6 +35,8 @@ func (*Client) arrowTypeToSqlite(t arrow.DataType) arrow.DataType {
 		return arrow.PrimitiveTypes.Float64
 	case arrow.BOOL:
 		return arrow.FixedWidthTypes.Boolean
+	case arrow.TIMESTAMP:
+		return arrow.FixedWidthTypes.Timestamp_us
 	default:
 		return arrow.BinaryTypes.LargeString
 	}
@@ -50,7 +54,9 @@ func (*Client) sqliteTypeToArrowType(t string) arrow.DataType {
 		return arrow.BinaryTypes.LargeBinary
 	case "boolean":
 		return arrow.FixedWidthTypes.Boolean
+	case "timestamp":
+		return arrow.FixedWidthTypes.Timestamp_us
 	default:
-		panic("unknown type")
+		panic("unknown type: " + t)
 	}
 }
