types

func InAscOrder ¶

func InAscOrder(fields ...string) Option

func InDescOrder ¶

func InDescOrder(fields ...string) Option

func WithFilter ¶

func WithFilter(field string, value ...interface{}) Option

WithFilter applies a WHERE clause for the given column. IMPORTANT: `field` MUST be a trusted, hardcoded column name. NEVER pass user-supplied strings as `field`.

func WithPagination ¶

func WithPagination(page, pageSize int) Option

func WithSearchQuery ¶

func WithSearchQuery(q string, fields ...string) Option

WithSearchQuery applies a WHERE clause searching `q` across multiple text fields using OR. Uses LOWER() for case-insensitive matching across SQLite and PostgreSQL. IMPORTANT: `fields` MUST be trusted, hardcoded column names. NEVER pass user-supplied strings as `fields`.