JSONB and JSON field types with Postgres SQL [SOLVED]

[stoffman]

I'm using TSQLQuery to access Postgres database. And the table I'm querying has a JSONB type field in it.

If I query for the a standard field and the JSONB field. it just being ignored and not presented in the dataset.

If I query only for the JSONB field a get an exception: EDatabase - Missing (compatible) underlying dataset

Anyone has an experience with it ? how it can be solved? (I cannot cast the field to string in the query)

Thanks

[stoffman]

It seems that TSQLQuery cannot handle JSON and JSONB field types.

the Zeos components can (https://wiki.lazarus.freepascal.org/Zeos_tutorial)