steampipe-postgres-fdw QualDefsToQuals: unsupported qual value (type T

It seems that some of the quals are not handled.

Example query:

SELECT key FROM jira_issue WHERE status = 'done' AND resolution_date >= (now() - '2 weeks'::interval)::timestamp

Results in the following warning (and whole qual is therefore skipped):

2025-02-04 20:54:29.494 UTC [INFO]  hub: failed to convert qual value; QualDefsToQuals: unsupported qual value (type T_FuncExpr), skipping

A simple fix for the situation I figured is to use (now() - '2 weeks'::interval)::timestamptz (note the timestamptz) however I'm not sure if that's always the case.

Feb 14 '25 09:02 mariusgrigaitis

Thanks @mariusgrigaitis, for raising this detailed issue. I will try and get it reproduced.

Feb 28 '25 08:02 pskrbasu

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

May 01 '25 08:05 github-actions[bot]

This issue was closed because it has been stalled for 90 days with no activity.

Jun 01 '25 08:06 github-actions[bot]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

Aug 10 '25 08:08 github-actions[bot]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

Oct 18 '25 08:10 github-actions[bot]