public override void ConfigureCommand(NpgsqlCommand command) { var sql = Selector.ToSelectClause(_mapping); var @where = _schema.BuildWhereFragment(_mapping, _query); sql = sql.AppendWhere(@where, command); var orderBy = _query.ToOrderClause(_mapping); if (orderBy.IsNotEmpty()) { sql += orderBy; } sql = _query.AppendLimit(sql); sql = _query.AppendOffset(sql); command.AppendQuery(sql); }