public 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 += $" LIMIT {_rowLimit}";
sql = _query.AppendOffset(sql);
command.AppendQuery(sql);
}