Function New

pkg/sql/keywords/keywords.go:231–291

New creates a new Keywords instance with the specified SQL dialect and case sensitivity. The dialect parameter determines which dialect-specific keywords to include: - DialectGeneric: Standard SQL keywords only - DialectPostgreSQL: Includes PostgreSQL extensions (ILIKE, LATERAL, MATERIALIZED, RETUR

(dialect SQLDialect, ignoreCase bool)

//	    fmt.Println("LATERAL is a PostgreSQL keyword")
//	}
func New(dialect SQLDialect, ignoreCase bool) *Keywords {
	k := &Keywords{
		reservedKeywords: make(map[string]bool),
		keywordMap:       make(map[string]Keyword),
		dialect:          dialect,
		ignoreCase:       true, // Always use case-insensitive comparison for SQL keywords
		CompoundKeywords: make(map[string]models.TokenType),
	}

	// Initialize compound keywords
	k.CompoundKeywords["GROUP BY"] = models.TokenTypeKeyword
	k.CompoundKeywords["ORDER BY"] = models.TokenTypeKeyword
	k.CompoundKeywords["LEFT JOIN"] = models.TokenTypeKeyword
	k.CompoundKeywords["FULL JOIN"] = models.TokenTypeKeyword
	k.CompoundKeywords["CROSS JOIN"] = models.TokenTypeKeyword
	k.CompoundKeywords["NATURAL JOIN"] = models.TokenTypeKeyword
	k.CompoundKeywords["GROUPING SETS"] = models.TokenTypeKeyword // SQL-99 grouping operation
	// Materialized views and DDL compound keywords
	k.CompoundKeywords["MATERIALIZED VIEW"] = models.TokenTypeKeyword
	k.CompoundKeywords["IF EXISTS"] = models.TokenTypeKeyword
	k.CompoundKeywords["IF NOT EXISTS"] = models.TokenTypeKeyword
	k.CompoundKeywords["OR REPLACE"] = models.TokenTypeKeyword
	k.CompoundKeywords["WITH DATA"] = models.TokenTypeKeyword
	k.CompoundKeywords["WITH NO DATA"] = models.TokenTypeKeyword
	// Partitioning compound keywords
	k.CompoundKeywords["PARTITION BY"] = models.TokenTypeKeyword
	k.CompoundKeywords["LESS THAN"] = models.TokenTypeKeyword
	k.CompoundKeywords["CHECK OPTION"] = models.TokenTypeKeyword

	// Add standard keywords
	k.addKeywordsWithCategory(RESERVED_FOR_TABLE_ALIAS)
	k.addKeywordsWithCategory(ADDITIONAL_KEYWORDS)

	// Add dialect-specific keywords
	switch dialect {
	case DialectMySQL:
		k.addKeywordsWithCategory(MYSQL_SPECIFIC)
	case DialectMariaDB:
		// MariaDB is a superset of MySQL — load MySQL base first, then MariaDB extras
		k.addKeywordsWithCategory(MYSQL_SPECIFIC)
		k.addKeywordsWithCategory(MARIADB_SPECIFIC)
	case DialectPostgreSQL:
		k.addKeywordsWithCategory(POSTGRESQL_SPECIFIC)
	case DialectSQLite:
		k.addKeywordsWithCategory(SQLITE_SPECIFIC)
	case DialectSnowflake:
		k.addKeywordsWithCategory(SNOWFLAKE_SPECIFIC)
	case DialectClickHouse:
		k.addKeywordsWithCategory(CLICKHOUSE_SPECIFIC)
	}

	// Build O(1) lookup cache for compound keyword first-words
	k.compoundKeywordStarts = make(map[string]bool, len(k.CompoundKeywords))
	for compound := range k.CompoundKeywords {
		if idx := strings.Index(compound, " "); idx > 0 {
			k.compoundKeywordStarts[compound[:idx]] = true
		}
	}