We use dbt and it works really well, but when it comes to complex logic using UDF or something other than sql makes more sense.