Derived fields frim DB nodes

Hi!

Is there any possibility to create\adjust fields while workin ‘in-database’ in KNIME?

For example, I want to fill all nulls in my table that i select, then create several other fields, and only after that group by and go to local enviroment.

If there any possile ways to do it not writing ‘case when’ \ ‘coalesce’ in db query nodes?

Any help is greatly appreciated!