postgres library

Classes

Command: A command that mutates data (INSERT, UPDATE, DELETE).
DeleteCommand: A specialized Command for dynamic deletes by primary key.
InsertCommand: A specialized Command for dynamic inserts.
MutationResult: Information about a mutation (INSERT, UPDATE, DELETE).
NoOpMutationResult: A MutationResult for commands that were skipped (no-op).
Query<P, R extends Record>: P defines the input Parameter type. R defines the expected output Record type (serves as a token for custom linting).
Row<R extends Record>: R is the Expected Record type (enables compile-time key validation via custom linters).
RowSet<R extends Record>
SQL: Explicit SQL-null marker for dynamic commands.
SqliteParsers: Common parser logic for SQLite values.
SqlRecords: The core executor interface, supporting mutations and transactions.
SqlRecordsReadonly: Context for read-only operations.
UpdateCommand: A specialized Command for "patch" updates.

NoOpCommand → const String: Sentinel value for a command that does nothing (e.g., no fields to update).

SqlRecordsPostgres(Session session) → SqlRecords: Creates a SqlRecords instance from a Postgres pg.Session.

ParamMapper = Map<String, Object?> Function(P params): Maps a Record/Class to a SQLite named parameter map.
ResultSchema = Map<String, Type>: Best-effort schema definition using Dart's Type objects (e.g., int, String).