Query Editor Cannot Recognize Non-Updatable Fields

[lorenszendre]

I reviewed the Query Editor documentation, and it clearly states that fields that are concatenations or that are renamed -- will not be updated. But when I write a simple query, such as:

SELECT id, first_name, last_name, first_name || ' ' || last_name as the_name
FROM some_table

And then I insert a record, then Save Changes (F5) -- it gives me an error saying that field "the_name" does not exist in relation "some_table".

I get the same error when I try to do the following:

SELECT ST.id, ST.first_name, ST.last_name, (SELECT PT.person_type FROM person_type PT WHERE PT.id = ST.person_type_id) as the_type
FROM some_table ST

When I try to save a new record, it tells me that field "the_type" does not exist in relation "some_table". No kidding!

So I tried ' ' || (SELECT PT.person_type FROM person_type PT WHERE PT.id = ST.person_type_id) as the_type

But this does not work either. The Query Editor still shows that column with a pencil icon instead of a lock icon.

Can you please fix the code so that it recognizes when a field is not updatable?