I'm testing Retool with a very basic database of employees and contracts, with contracts being versioned using the "next" foreign key - the current contract for an employee has "next" and "end_date" set to null:
The problem is, when I try to construct a query in GUI mode and filter for null values, IS NULL does not work
and = NULL does not work either
is it an issue with the retool db, the interface or am I doing something wrong?