SQL should be the default choice for data transformation logic(robinlinacre.com)

    select * from {{ref('really_big_table')}}
    
    {% if incremental and target.schema == 'prod' %}
      where timestamp >= (select max(timestamp) from {{this}})
     {% else %}
      where timestamp >= dateadd(day, -3, current_date)
    {% endif %}

   CREATE TABLE varchars(v VARCHAR);
   PREPARE v1 AS SELECT v + 42 FROM varchars;

   ERROR:  operator does not exist: character varying + integer
   LINE 1: PREPARE v1 AS SELECT v + 42 FROM varchars;
                               ^
   HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

  main:
    from: payments
    alias: p
    distinct: true
    select:
      - apply: ["sum", "i.views"]
      - apply: ["sum", "i.clicks"]
      - apply: ["sum", "p.amount"]
    where:
      - apply: ["eql", "user_id", "12"]
    group:
      - apply: ["group_by", "date"]

   replace users (preference = "blue") where id = 123