GetTable returns a Table for a struct type.

Pagination is used with Query.Apply to set LIMIT and OFFSET from the URL values: - ?limit=10 - sets q.Limit(10), max limit is 1000.

RegisterTable registers a struct as SQL table.

SetTableNameInflector overrides the default func that pluralizes model name to get table name, e.g.

URLFilters is a shortcut for NewURLFilter(urlValues).Filters.

Table represents a SQL table created from Go struct.

URLFilter is used with Query.Apply to add WHERE clauses from the URL values: - ?foo=bar - Where(`"foo" = 'bar'`) - ?foo=hello&foo=world - Where(`"foo" IN ('hello','world')`) - ?foo__exclude=bar - Where(`"foo" != 'bar'`) - ?foo__ieq=bar - Where(`"foo" ILIKE 'bar'`) - ?foo__match=bar - Where(`"foo" SIMILAR TO 'bar'`) - ?foo__gt=42 - Where(`"foo" > 42`) - ?foo__gte=42 - Where(`"foo" >= 42`) - ?foo__lt=42 - Where(`"foo" < 42`) - ?foo__lte=42 - Where(`"foo" <= 42`).

ColumnScanner is used to scan column values.

DB is a common interface for pg.DB and pg.Tx types.

A Result summarizes an executed SQL command.