@Shu_ashu : Thank you so much for the link, it covers part of my need.
The other thing is to assign the lookup value to attribute so I think the solution is
ExecuteSQL -> ConvertAvroToJson -> EvaluateJsonPath
can we do it in one step instead of 3 like above? All I am pulling is one field from the database table.
Query: select id from table A