Method JSONExtractText

internal/store/dialect.go:33–33

JSONExtractText returns SQL to extract a text value from a JSON column. SQLite: json_extract(col, '$.key') PostgreSQL: col->>'key'

(column, key string)

	// SQLite: json_extract(col, '$.key')
	// PostgreSQL: col->>'key'
	JSONExtractText(column, key string) string

	// JSONExtractPath returns SQL to extract a value at a dotted path from a JSON column.
	// SQLite: json_extract(col, '$.path.to.key')