public override string BuildSql(SqlOptions sqlOptions)
{
switch (sqlOptions.DatabaseType)
{
case SqlDatabaseType.Postgres:
{
var left = LeftOperand.BuildSql(sqlOptions, FlowOptions.Construct(this));
var right = RightOperand.BuildSql(sqlOptions, FlowOptions.Construct(this));
var command = sqlOptions.Command("ILIKE");
return($"{left} {command} {right}");
}
default:
{
return(new LikeOperator(LeftOperand.Lower(), RightOperand.Lower()).BuildSql(sqlOptions, FlowOptions.Construct(this)));
}
}
}