Fill the type mappings

[nils-braun]

There are many SQL types and relevant python types in the SQL to python mappings in mappings.py still missing.
Those can be added one-by-one.

[raybellwaves]

https://www.w3schools.com/sql/sql_datatypes.asp
Believe this is of reference
and
https://calcite.apache.org/javadocAggregate/org/apache/calcite/sql/type/SqlTypeName.html

[raybellwaves]

Types: (x indicates it is has been included)

• ANY
• ARRAY
• BIGINT
• BINARY
• BOOLEAN
• CHAR
• CURSOR
• DATE
• DECIMAL
• DOUBLE
• GEOMETRY
• INTEGER
• INTERVAL
• MAP
• MULTISET
• NUMERIC
• REAL
• ROW
• SMALLINT
• SYMBOL
• TIME
• TIMESTAMP
• TINYINT
• VARBINARY
• VARCHAR

Spatial types

• GEOMETRY
• POINT
• CURVE
• LINESTRING
• SURFACE
• POLYGON
• POLYHEDRALSURFACE
• GEOMETRYCOLLECTION
• MULTIPOINT
• MULTICURVE
• MULTILINESTRING
• MULTISURFACE
• MULTIPOLYGON

[nils-braun]

Thank you very much for giving the references @raybellwaves!
I added the remaining entries to your list (sorry for editing one of your comments)

[raybellwaves]

Np at all. I was originally planning to add them all but had to drop off. Expect me to very intermittent :) but looking forward to contributing nonetheless

[nils-braun]

I have updated the type mappings from the Calcite Documentation