docs: def _generateDDL(self):
          """Generate DDL statements for SQLLite"""
          sql = []
          # Next convert each set of columns into a table structure
          for dataset_name in sorted(self.datasets.keys()):
  
              # SQL to drop the table if it already exists
              sql.append('''drop table if exists %s;''' % dataset_name)
  
              # Generate the SQL for the cols
              cols = self.datasets[dataset_name]
              col_defs = []
              for col in cols:
                  sql_datatype = self.getSQLDataType(col["vartype"])
                  col_defs.append("%s %s" % (col["varname"], sql_datatype,))
  
              stmt = 'CREATE TABLE %s (%s)' % (dataset_name, ','.join(col_defs))
              sql.append(stmt)
  
          return sql