Custom Data Type via Alembic for H3 (Hexagonal hierarchical geospatial indexing system)

Question

I'm currently developing a project that requires storing H3Index (https://h3geo.org/docs/core-library/h3Indexing/) values in my database using SQLAlchemy and Alembic for migrations. However, my search for existing libraries supporting H3Index has been unsuccessful. I'm considering alternatives to implement this custom datatype. Given that I've successfully utilized libraries like geoalchemy2 for similar custom types, I'm contemplating whether a similar approach could be used for H3Index. Here's my proposed approach and the issues I've encountered with it:

Snippet from custom types that have worked -- but there is a library

from geoalchemy2 import Geometry

# Example of using geoalchemy2 for a custom type
city_center_point = Column(
    Geometry('POINT', 4326, from_text='ST_GeomFromEWKT', name='geometry'), nullable=False)

# Example of using a custom type with server_default
is_disabled = db.Column(db.Boolean, nullable=False,
                        server_default=db.FetchedValue())

However, since there's no readily available library for H3Index (unless someone knows of an h3 library for alembic?), I haven't been able to implement it as easily as the example above. My proposed solution was to create a custom datatype for H3Index using SQLAlchemy's TypeDecorator. Here's the code for the proposed custom datatype and Alembic migration :

from sqlalchemy import types
from sqlalchemy.dialects.postgresql import UUID

class H3Index(types.TypeDecorator):
    impl = UUID

    def process_bind_param(self, value, dialect):
        if value is not None:
            # Convert H3Index to string representation
            return str(value)
        return None

    def process_result_value(self, value, dialect):
        if value is not None:
            # Convert string representation to H3Index
            return H3Index(value)
        return None

    """Add H3Index column
    
    Revision ID: abc123
    Revises: xyz789
    Create Date: 2024-03-21 10:00:00
    """
    
    from alembic import op
    import sqlalchemy as sa
    from sqlalchemy import Column
    
    # Import the custom datatype class
    from yourmodule import H3Index
    
    # revision identifiers, used by Alembic.
    revision = 'abc123'
    down_revision = 'xyz789'
    branch_labels = None
    depends_on = None
    
    def upgrade():
        # Add the column with H3Index datatype
        op.add_column('your_table', 
                      Column('h3_index', H3Index, nullable=True))
    
    def downgrade():
        # Drop the column
        op.drop_column('your_table', 'h3_index')

Despite writing this solution, I know it won't work I was just trying to get a ball rolling. Could someone provide guidance on whether this approach is feasible for implementing a custom datatype for H3Index in SQLAlchemy with Alembic migrations? Additionally, are there alternative approaches I could consider? Any insights or suggestions would be greatly appreciated. Thank you!