With conman I get

ERROR: function lower(jsonb) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. 

@mksybr We'll need a lot more information to help you with that 🙂 How are you doing the query that causes that error?

It looks like conman wraps HugSQL -- do you have your queries in separate .sql files that are being loaded by conman/HugSQL?

If so, you can put whatever SQL you need -- including casts -- into the .sql file.

Ugh, conman uses a global dynamic var for the connection 😞

Sorry for the delay. Yes I have the causitive query: Sometimes its get-user-by-username, othertimes its get-user-by-email

-- :name get-user-by-username
-- :command :query
-- :result :one
-- :doc Selects the user matching the username
SELECT
  id,
  status,
  email,
  username,
  password,
  user_data,
  history,
  permissions
  FROM
      users
 WHERE
  LOWER(username) = LOWER(:username);

-- :name get-user-by-email
-- :command :query
-- :result :one
-- :doc Selects the user matching the email
SELECT
  id,
  status,
  email,
  username,
  password,
  user_data,
  history,
  permissions
  FROM
      users
 WHERE
  LOWER(email) = LOWER(:email);

The JSONB error usually happens when you pass a map or vector to the query function. I would sprinkle some assert here and there to verify that the email key is indeed a string

(or spec, or Schema etc)