Function Example_extractFromCTE

pkg/gosqlx/example_test.go:634–648

Example_extractFromCTE demonstrates extracting from queries with CTEs.

()

// Example_extractFromCTE demonstrates extracting from queries with CTEs.
func Example_extractFromCTE() {
	sql := `WITH active_users AS (
		SELECT id, name FROM users WHERE active = true
	)
	SELECT name, COUNT(*) FROM active_users GROUP BY name`

	ast, err := gosqlx.Parse(sql)
	if err != nil {
		log.Fatal(err)
	}

	metadata := gosqlx.ExtractMetadata(ast)
	fmt.Printf("Tables found: %d\n", len(metadata.Tables))
	// Output: Tables found: 2
}

// Example_validationWithExtraction demonstrates combining validation with metadata extraction.
func Example_validationWithExtraction() {