Is it possible to use PostgreSQL insert with returning clause with Camel sql component? This insert statement works fine on its own (inserting and also returning id and token), but when used in a Camel route, the insert gets processed but exchange body is returned empty. Why?
INSERT INTO my_table(token) values(:#new_token) ON CONFLICT (token) DO UPDATE SET token=excluded.token returning id, token