code: def giant_text_sqltype(dialect: Dialect) -> str:
      
      if dialect.name == SqlaDialectName.SQLSERVER:
          return 'NVARCHAR(MAX)'
      elif dialect.name == SqlaDialectName.MYSQL:
          return 'LONGTEXT'
      else:
          raise ValueError("Unknown dialect: {}".format(dialect.name))
docs: Returns the SQL column type used to make very large text columns for a
      given dialect.
  
      Args:
          dialect: a SQLAlchemy :class:`Dialect`
      Returns:
          the SQL data type of "giant text", typically 'LONGTEXT' for MySQL
          and 'NVARCHAR(MAX)' for SQL Server.