case isCreateTableAsSelect(upper):
		// CREATE TABLE name AS SELECT ...
		tableName := extractTableNameAsSelect(sql)
		return DDLStatement{SQL: sql, Type: "CREATE_TABLE_AS", TableName: tableName}

// isCreateTableAsSelect checks if SQL is CREATE TABLE ... AS SELECT
func isCreateTableAsSelect(upper string) bool {
	if !strings.HasPrefix(upper, "CREATE TABLE") {
		return false
	}
	// Look for AS followed by whitespace and SELECT
	rest := upper[12:] // len("CREATE TABLE")
	
	// Find AS (followed by whitespace)
	asIdx := strings.Index(rest, " AS")
	if asIdx == -1 {
		return false
	}
	
	// Check if what follows AS is whitespace and then SELECT
	afterAs := rest[asIdx+3:] // skip " AS"
	afterAs = strings.TrimSpace(afterAs)
	return strings.HasPrefix(afterAs, "SELECT")
}

// extractTableNameAsSelect extracts table name from CREATE TABLE ... AS SELECT
func extractTableNameAsSelect(sql string) string {
	// CREATE TABLE name AS SELECT
	// or CREATE TABLE name AS\nSELECT (multiline)
	upper := strings.ToUpper(sql)
	idx := strings.Index(upper, "CREATE TABLE")
	if idx == -1 {
		return ""
	}
	rest := sql[idx+12:]
	rest = strings.TrimSpace(rest)
	// Find " AS" (followed by whitespace that leads to SELECT)
	asIdx := strings.Index(strings.ToUpper(rest), " AS")
	if asIdx == -1 {
		return ""
	}
	name := strings.TrimSpace(rest[:asIdx])
	return name
}