Where clauses with variables

[flintforge]

I'd like to bring your attention on the fact that where clauses will only resolve for constants.
The following works:

select a_field from a_table where a_field='a value'; 

but in this case

select a_field from a_table where a_field=a_func.parameter;

query parameters needs to be replaced by a value, from execution state, as mentioned here:

wrappers/supabase-wrappers/src/qual.rs

Line 195 in 2a3f985

// add a dummy value if this is query parameter, the actual value

This is limitation of the current implementation that should be mentioned here:

wrappers/supabase-wrappers/src/interface.rs

Line 457 in 2a3f985

/// <strong>Warning</strong>: Currently only simple conditions are supported, see below for examples. Other kinds of conditions, like JSON attribute filter e.g. `where json_col->>'key' = 'value'`, are not supported yet.

Thanks for any suggestion or direction to look from here in order to overcome that limitation.

[burmecia]

Thanks for reporting this issue. I've done some testing but cannot reproduce this issue, can you give more details? FYI, below is the testing code I am using:

create foreign data wrapper stripe_wrapper
  handler stripe_fdw_handler
  validator stripe_fdw_validator;

create server stripe_server
  foreign data wrapper stripe_wrapper
  options (
    api_key 'sk_test_...'
  );

create schema if not exists stripe;

-- create foreign table
create foreign table stripe.balance (
  balance_type text,
  amount bigint,
  currency text,
  attrs jsonb
)
  server stripe_server
  options (
    object 'balance'
  );

-- create a function using parameter in query
create function public.get_stripe_balance(bt text)
returns table (
  balance_type text,
  amount bigint
)
language plpgsql
security definer set search_path = ''
as $$
begin
  return query
  select
    t.balance_type,
    t.amount
  from
    stripe.balance t
  where
    t.balance_type = get_stripe_balance.bt
  ;
end;
$$;

select * from get_stripe_balance('available');