inscript

Language reference

Conditions are explicit.

Readable operators define comparisons without leaving prose.

filter the orders where total is above 50 and status is active

Mixed and/or conditions are parsed deterministically. When the result may surprise a non-programmer, Inscript uses amber confirmation before execution.

filter the orders where total is above 50 and status is active or status is pending

I'll read this as: (total is above 50 and status is active) or status is pending. Is that what you mean?