code: def _sqlite_to_python_types(self, sqlite_type: str):
      mapping = {
          "INT": int,
          "INTEGER": int,
          "TINYINT": int,
          "SMALLINT": int,
          "MEDIUMINT": int,
          "BIGINT": int,
          "UNSIGNED BIG INT": int,
          "INT2": int,
          "INT8": int,
          "CHARACTER": str,
          "VARCHAR": str,
          "VARYING CHARACTER": str,
          "NCHAR": str,
          "NATIVE CHARACTER": str,
          "NVARCHAR": str,
          "TEXT": str,
          "CLOB": str,
          "BLOB": bytes,
          "REAL": float,
          "DOUBLE": float,
          "DOUBLE PRECISION": float,
          "FLOAT": float,
          "NUMERIC": float,
          "DECIMAL": float,
          "BOOLEAN": bool,
          "DATE": datetime.date,
          "DATETIME": datetime.datetime,
      }
  
      sqlite_type = sqlite_type.split("(")[0].strip().upper()
  
      if sqlite_type in mapping:
          return mapping[sqlite_type]
      else:
          raise Exception(
              f"Unsupported column {sqlite_type} encountered in the sqlite table. Please raise a feature request!"
          )
  
file_path: evadb/evadb/third_party/databases/sqlite/sqlite_handler.py
imports: import datetime
  import sqlite3
  import pandas
  from evadb.third_party.databases.types import DBHandler, DBHandlerResponse, DBHandlerStatus
label_desc: Use image node_id 10 for calling the SQLiteHandler obj's underlying member method code with example usage: obj._sqlite_to_python_types(sqlite_type) and returns: mapping