enginesql

Sep 20, 2026

Changes in this version

type Flavor

+ IncrementExpr func(table, col string) string

+ func (f Flavor) UpsertIncrementExpr(table, col string) (string, error)

Sep 20, 2026

Changes in this version

+ func FinalizePage[T any](p *PreparedListQuery, entities []T, totalCount int64) ([]T, int64)

type StructMeta

+ func (m *StructMeta) PKIsZero(entity any) bool

Aug 16, 2026

Changes in this version

type StructMeta

+ func (m *StructMeta) FieldIndicesExcludingColumns(excludedCols []string) ([]string, []int)

+ func (m *StructMeta) ProjectionColumns(q r3.Query) ([]string, []int)

+ func (m *StructMeta) ScanDestForFieldIndices(entityPtr any, fieldIndices []int) []any

+ func (m *StructMeta) SelectColumns(q r3.Query) ([]string, error)

Aug 5, 2026

Changes in this version

type RelationMeta

+ WhereColumn string

+ WhereValue string

Jul 22, 2026

Changes in this version

type StructMeta

+ func (m *StructMeta) CopyColumnFields(dstPtr any, src any)

Jul 21, 2026

Changes in this version

type Flavor

+ BucketExpr func(col string, unit r3.BucketUnit) (string, error)

+ func (f Flavor) DateTruncExpr(col string, unit r3.BucketUnit) (string, error)

type PreparedAggregateQuery

+ BucketExprs []string

Jul 16, 2026

Changes in this version

type RelationMeta

+ OrderColumn string

Jul 9, 2026

Changes in this version

type PreparedListQuery

+ func PrepareMergedListQuerySchema(schema r3.Schema, q r3.Query) (PreparedListQuery, error)

Jul 9, 2026

Changes in this version

type RelationMeta

+ func RelationMetaFromSpec(spec r3.RelationSpec) RelationMeta

type StructMeta

+ func WithDeclaredRelations(meta StructMeta, specs []r3.RelationSpec) StructMeta

Jul 8, 2026

Changes in this version

type BaseCRUD

+ func (r *BaseCRUD[T, ID]) PatchWhere(ctx context.Context, filters r3.Filters, entity T, fields r3.Fields) (int64, error)

+ func (r *BaseCRUD[T, ID]) Upsert(ctx context.Context, entity T, opts ...r3.UpsertOption) (T, error)

type Flavor

+ UsesOnConflictClause bool

+ func (f Flavor) UpsertClause(conflictCols, updateCols []string) string

Jul 8, 2026

Changes in this version

+ func ScanAggregateRows(rows *sql.Rows) ([]r3.AggregateRow, error)

type BaseCRUD

+ func (r *BaseCRUD[T, ID]) Aggregate(ctx context.Context, qarg ...r3.Query) ([]r3.AggregateRow, error)

+ type PreparedAggregateQuery struct

+ GroupBy []string

+ Having r3sql.SQLClause

+ SelectList []string

+ func PrepareAggregateQuery(dm *DefaultsManager, schema r3.Schema, qarg ...r3.Query) (PreparedAggregateQuery, error)

+ func PrepareMergedAggregateQuery(schema r3.Schema, q r3.Query) (PreparedAggregateQuery, error)

Jun 26, 2026

Changes in this version

+ const RelBelongsTo

+ const RelHasMany

+ const RelManyToMany

+ var FlavorMySQL = Flavor

+ var FlavorPostgres = Flavor

+ var FlavorSQLite = Flavor

+ func ColumnsString(cols []string) string

+ func FieldsToColumns(fields r3.Fields) []string

+ func FinalizeCount[T any](entities []T, paginatedCount int64, isPaginated bool) ([]T, int64)

+ func ManagedTimestampColumns(meta StructMeta, naming r3.NamingConfig, op r3.WriteOp) []string

+ func NewBaseQuerier[T any, ID comparable](db *sql.DB, flavor Flavor, opts ...r3.Option) r3.Querier[T, ID]

+ func RequireMutableColumns(ctx context.Context, schema r3.Schema, cols []string) error

+ func RunPreloads(ctx context.Context, executor SQLExecutor, meta *StructMeta, flavor Flavor, ...) error

+ func ScanEntities[T any](rows *sql.Rows, meta *StructMeta) ([]T, error)

+ func SetTimeColumns(meta StructMeta, entityPtr any, cols []string, t time.Time)

+ func WriteColumns(ctx context.Context, schema r3.Schema, cols []string, op r3.WriteOp) []string

+ type BaseCRUD struct

+ Config r3.Config

+ Executor SQLExecutor

+ Flavor Flavor

+ Meta StructMeta

+ Raw *BaseRaw[T, ID]

+ Schema r3.Schema

+ func NewBaseCRUD[T any, ID comparable](db *sql.DB, flavor Flavor, opts ...r3.Option) *BaseCRUD[T, ID]

+ func (r *BaseCRUD[T, ID]) BeginTx(ctx context.Context) (r3.TxCRUD[T, ID], error)

+ func (r *BaseCRUD[T, ID]) Count(ctx context.Context, qarg ...r3.Query) (int64, error)

+ func (r *BaseCRUD[T, ID]) Create(ctx context.Context, entity T) (T, error)

+ func (r *BaseCRUD[T, ID]) Delete(ctx context.Context, id ID) error

+ func (r *BaseCRUD[T, ID]) Get(ctx context.Context, id ID, qarg ...r3.Query) (T, error)

+ func (r *BaseCRUD[T, ID]) HardDelete(ctx context.Context, id ID) error

+ func (r *BaseCRUD[T, ID]) List(ctx context.Context, qarg ...r3.Query) ([]T, int64, error)

+ func (r *BaseCRUD[T, ID]) Patch(ctx context.Context, entity T, fields r3.Fields) (T, error)

+ func (r *BaseCRUD[T, ID]) Restore(ctx context.Context, id ID) error

+ func (r *BaseCRUD[T, ID]) SQLDB() *sql.DB

+ func (r *BaseCRUD[T, ID]) Update(ctx context.Context, entity T) (T, error)

+ type BaseRaw struct

+ Executor SQLExecutor

+ Meta StructMeta

+ func NewBaseRaw[T any, ID comparable](executor SQLExecutor, meta StructMeta) *BaseRaw[T, ID]

+ func (r *BaseRaw[T, ID]) Exec(ctx context.Context, query string, args ...any) (sql.Result, error)

+ func (r *BaseRaw[T, ID]) Query(ctx context.Context, query string, args ...any) ([]T, error)

+ func (r *BaseRaw[T, ID]) QueryRow(ctx context.Context, query string, args ...any) (T, error)

+ type Defaults = r3.Defaults

+ func NewDefaults() Defaults

+ type DefaultsManager = r3.DefaultsManager

+ func NewDefaultsManager() DefaultsManager

+ type Flavor struct

+ IdentifierQuote string

+ Placeholder PlaceholderStyle

+ SupportsRETURNING bool

+ TimestampFunc string

+ func (f Flavor) ConvertPlaceholders(clause string, startIdx int) (string, int)

+ func (f Flavor) Placeholders(count int, startIdx int) string

+ func (f Flavor) QuoteIdentifiers(sql string) string

+ func (f Flavor) SetExprs(cols []string, startIdx int) string

+ func (f Flavor) WhereEq(column string, nextIdx int) string

+ type PlaceholderStyle int

+ const PlaceholderDollar

+ const PlaceholderQuestion

+ type PreparedListQuery struct

+ Clauses r3sql.SQLClauses

+ CursorBackward bool

+ CursorClause r3sql.SQLClause

+ CursorLimit int

+ IsCursorPaginated bool

+ IsPaginated bool

+ Limit int

+ Offset int

+ Query r3.Query

+ Sorts []r3sql.SQLSort

+ func PrepareListQuery(dm *DefaultsManager, qarg ...r3.Query) (PreparedListQuery, error)

+ func PrepareMergedListQuery(q r3.Query) (PreparedListQuery, error)

+ func (p *PreparedListQuery) Joins() []r3sql.SQLColumn

+ func (p *PreparedListQuery) OrderBySorts() ([]r3sql.SQLSort, error)

+ type RelationKind = r3tag.RelationKind

+ type RelationMeta struct

+ FKColumn string

+ FieldIndex int

+ FieldName string

+ JoinTable string

+ Kind RelationKind

+ Owned bool

+ RefColumn string

+ TargetMeta StructMeta

+ TargetType reflect.Type

+ type SQLExecutor interface

+ ExecContext func(ctx context.Context, query string, args ...any) (sql.Result, error)

+ QueryContext func(ctx context.Context, query string, args ...any) (*sql.Rows, error)

+ QueryRowContext func(ctx context.Context, query string, args ...any) *sql.Row

+ type StructMeta struct

+ Columns []string

+ Fields []int

+ PKColumn string

+ PKField int

+ Relations []RelationMeta

+ SoftDeleteColumn string

+ TableName string

+ func GetStructMeta[T any]() StructMeta

+ func (m *StructMeta) FieldIndicesForColumns(selectedCols []string) ([]string, []int)

+ func (m *StructMeta) FieldValues(entity any) []any

+ func (m *StructMeta) FieldValuesForColumns(entity any, columns []string) []any

+ func (m *StructMeta) NonPKColumns() []string

+ func (m *StructMeta) NonPKFieldValues(entity any) []any

+ func (m *StructMeta) PKValue(entity any) any

+ func (m *StructMeta) ScanDest(entityPtr any) []any

+ func (m *StructMeta) ScanDestForColumns(entityPtr any, selectedCols []string) []any

+ func (m *StructMeta) SetPKValue(entityPtr any, val any)

+ func (m *StructMeta) ValidatePatchColumns(columns []string) ([]string, error)