title: Redshift how to call python UDF inside sql UDF
body: <p>Does anyone know if redshit is not supporting call python UDFs inside sql UDFs?</p>
  <p>The following code is returning <code>syntax error at or near &quot;return&quot; Position: 2</code> for me. Interestingly, I can call the function directly without problem. e.g. <code>select ds_build_cn.public.chui_sqludf('blah')</code>.
  I'm in China region, so this might be a region thing</p>
  <pre><code>create or replace function ds_build_cn.public.chui_pyudf(locale_code varchar(255))
      returns varchar(255)
      immutable  -- when called with the same inputs, returns the same results
  as
  $$
  return 'blah'
  $$
      language plpythonu
  ;
  
  create or replace function ds_build_cn.public.chui_sqludf(locale_code varchar(255))
      returns varchar(255)
      immutable  -- when called with the same inputs, returns the same results
  as
  $$
  select ds_build_cn.public.chui_pyudf($1)
  $$
      language sql
  ;
  
  create table ds_build_cn.public.chui_anytable as select 1;
  
  select ds_build_cn.public.chui_sqludf('blah')
  from ds_build_cn.public.chui_anytable
  limit 10;
  
  -- [42601][500310] [Amazon](500310) Invalid operation: syntax error at or near &quot;return&quot; Position: 2;
  </code></pre>