strange key with jsonb about hugsql

[csummers]

Scratch everything from my last/deleted comment. That's the value that PG returns directly for a json path unless you give it an alias:

playground=# select id, imagemeta->'balance' from playground;
 id | ?column? 
----+----------
  1 | 7.77
(1 row)

playground=# select id, imagemeta->'balance' as balance from playground;
 id | balance 
----+---------
  1 | 7.77
(1 row)

[csummers]

So, if you want to specify the field as an identifier parameter type in the column alias, you could do:

select id, imagemeta->:field as :i:field from playground

[Xylon2]

Ah, thankyou! So not a bug at-all then.