Error : No method asJSON S3 class: pq_<not_supported_type> is raised when try to import data from PostgreSQL

When you try to import data from a PostgreSQL instance, you might get the below error if your SQL query contains columns whose data type is not supported in Exploratory. (For example, pq_NA)

Error : No method asJSON S3 class: pq_NA

If this is the case, you might want to update your SQL query to convert/cast the data type to something more common such as text.

ref: https://postgis.net/docs/ST_AsText.html