Function Example_reservedVsNonReserved

pkg/sql/keywords/example_test.go:133–164

Example_reservedVsNonReserved demonstrates distinction between reserved and non-reserved keywords.

()

// Example_reservedVsNonReserved demonstrates distinction between reserved and non-reserved keywords.
func Example_reservedVsNonReserved() {
	kw := keywords.New(keywords.DialectGeneric, true)

	// Reserved keywords (cannot be used as identifiers)
	reserved := []string{"SELECT", "FROM", "WHERE", "JOIN"}
	fmt.Println("Reserved keywords:")
	for _, word := range reserved {
		if kw.IsReserved(word) {
			fmt.Printf("  - %s\n", word)
		}
	}

	// Non-reserved keywords (window functions - can be used as identifiers in some contexts)
	nonReserved := []string{"ROW_NUMBER", "RANK", "DENSE_RANK"}
	fmt.Println("Non-reserved keywords:")
	for _, word := range nonReserved {
		if kw.IsKeyword(word) && !kw.IsReserved(word) {
			fmt.Printf("  - %s\n", word)
		}
	}

	// Output:
	// Reserved keywords:
	//   - SELECT
	//   - FROM
	//   - WHERE
	//   - JOIN
	// Non-reserved keywords:
	//   - ROW_NUMBER
	//   - RANK
	//   - DENSE_RANK
}

// Example_dialectComparison demonstrates differences between SQL dialects.
func Example_dialectComparison() {