QueryBuilder and JSON fields

[pphunor72]

Describe the bug
QueryBuilder does not generate proper SQL statement.

To Reproduce
Steps to reproduce the behavior:

1. I have an entity with optional lastPos field of type JSONB, and I want to update it, and use it to build a where condition as well.

2. Try to run the following:

qb.update(details).where(
{ $and: [
    { id: 'b47f1cca-90ca-11ec-99e0-42010a5d800c' },
    { $or: [
	    { lastPos: { $eq: null } },
	    { lastPos: { time: { $lt: 1646147306 } } }
    ]}
]});

3. The resulting query is as follows:

update "devices" set "last_pos" = '{...}'
where "id" = 'b47f1cca-90ca-11ec-99e0-42010a5d800c'
and ("d0"."last_pos"->>'undefined' is null or ("d0"."last_pos"->>'time')::float8 < 1646147306)

4. The issues:
   • "d0" table alias is not set, but it is used.
   • cannot check if this JSONB field is null or not. At least the same check as for any other non-JSONB type field does not work. How should be this done properly?

Versions

Dependency	Version
node	16.13.1
mikro-orm	5.0.5
your-driver	postgresql