Timestamp/Datetime issue? about fudgeo HOT 5 CLOSED

import pathlib
from datetime import timezone
from faker import Faker

from fudgeo.geopkg import GeoPackage, SpatialReferenceSystem, Field
from fudgeo.enumeration import GeometryType, SQLFieldType
from fudgeo.geometry import Point
from fudgeo.sql import ESRI_4326

from fudgeo import __version__

assert __version__ == '0.2.0'

fake = Faker()

# Create or connect to GeoPackage
path_gpkg = pathlib.Path.cwd().joinpath("fudgeo_tutorial.gpkg")
if path_gpkg.exists():
    gpkg = GeoPackage(path_gpkg)
else:
    gpkg = GeoPackage.create(path_gpkg)
srs = SpatialReferenceSystem("GCS_WGS_1984", "EPSG", 4326, ESRI_4326)

# Fake up some data
rows = []
for _ in range(100):
    lat, lon, city, cc, tz = fake.location_on_land()
    lon = float(lon)
    lat = float(lat)
    rows.append((fake.name(), city, cc, lon, lat, fake.date_object(),
                 fake.date_time(), fake.date_time(tzinfo=timezone.utc),
                 Point(x=lon, y=lat, srs_id=4326)))

# Define fields
fields = (
    Field("full_name", SQLFieldType.text),
    Field("city", SQLFieldType.text),
    Field("country_code", SQLFieldType.text, 2),
    Field("longitude", SQLFieldType.float),
    Field("latitude", SQLFieldType.float),
    Field("my_date", SQLFieldType.date),
    # These next 2 are the ones that have issues:
    Field("my_datetime", SQLFieldType.datetime),
    Field("my_datetime_tz", SQLFieldType.datetime),
)

# Create feature class
table_name = "Datetime_Test"
fc = gpkg.create_feature_class(table_name, srs, fields=fields,
                               shape_type=GeometryType.point, overwrite=True)

# Write out the data
with gpkg.connection as conn:
    conn.executemany(
        f"""INSERT INTO {table_name} (
                full_name, city, country_code,
                longitude, latitude, my_date, 
                my_datetime, my_datetime_tz, SHAPE) 
           VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)""", rows)

# Selecting the date and datetime columns gives date and datetime objects
with gpkg.connection as conn:
    cursor = conn.execute(f"""SELECT my_date, my_datetime, my_datetime_tz FROM {table_name}""")
    features = cursor.fetchall()

# table will now show in ArcGIS Desktop and ArcGIS Pro with 
# Date type fo the date and datetime columns

# Define fields
fields = (
    Field("full_name", SQLFieldType.text),
    Field("city", SQLFieldType.text),
    Field("country_code", SQLFieldType.text, 2),
    Field("longitude", SQLFieldType.float),
    Field("latitude", SQLFieldType.float),
    Field("date", SQLFieldType.date),
    # These next 2 are the ones that have issues:
    Field("datetime", "DATETIME"),
    Field("datetime_tz", SQLFieldType.timestamp),
)

...

with gpkg.connection as conn:
    cursor = conn.execute("""SELECT datetime "[timestamp]" FROM Datetime_Test""")
    features = cursor.fetchall()