A Query with columns only

[dimminbox]

I try to run a complicated query that considering a part like c.MinAmount > c.Amount where both parts are columns in Postgres.

StackTrace is:

error variable 'c' of type 'Orders.Core.Models.Entites.Buffer' referenced from scope '', but it is not defined, stacktrace at System.Linq.Expressions.Compiler.VariableBinder.Reference(ParameterExpression node, VariableStorageKind storage)
at System.Linq.Expressions.Compiler.VariableBinder.VisitParameter(ParameterExpression node)
at System.Linq.Expressions.Compiler.VariableBinder.VisitUnary(UnaryExpression node)
at System.Linq.Expressions.ExpressionVisitor.Visit(ReadOnlyCollection1 nodes) at System.Linq.Expressions.Compiler.VariableBinder.VisitLambda[T](Expression1 node)
at System.Linq.Expressions.Compiler.VariableBinder.Bind(LambdaExpression lambda)
at System.Linq.Expressions.Compiler.LambdaCompiler.Compile(LambdaExpression lambda)
at System.Linq.Expressions.Expression1.Compile() at MicroOrm.Dapper.Repositories.SqlGenerator.ExpressionHelper.GetValue(Expression member, String& parameterName) at MicroOrm.Dapper.Repositories.SqlGenerator.ExpressionHelper.GetValue(Expression member, String& parameterName) at MicroOrm.Dapper.Repositories.SqlGenerator.ExpressionHelper.GetValue(Expression member) at MicroOrm.Dapper.Repositories.SqlGenerator.SqlGenerator1.GetQueryProperties(Expression expr, ExpressionType linkingType)
at MicroOrm.Dapper.Repositories.SqlGenerator.SqlGenerator1.GetQueryProperties(Expression expr) at MicroOrm.Dapper.Repositories.SqlGenerator.SqlGenerator1.AppendWherePredicateQuery(SqlQuery sqlQuery, Expression1 predicate, QueryType queryType) at MicroOrm.Dapper.Repositories.SqlGenerator.SqlGenerator1.GetSelect(Expression1 predicate, Boolean firstOnly, FilterData filterData, Expression1[] includes)
at MicroOrm.Dapper.Repositories.SqlGenerator.SqlGenerator1.GetSelectAll(Expression1 predicate, FilterData filterData, Expression1[] includes) at Relef.Repository.Repository1.ListAsync(IReadOnlyList1 filter, Expression1[] includes, FilterLogic logic, IReadOnlyList`1 sort, UInt32 limit, UInt32 offset, CancellationToken cancellationToken)

Is it possible to run queries like this?

[phnx47]

@dimminbox Currently impossible.