Regarding recursion

hello sir,
How to create a recursion in dremio DB, if we cannot, then is there any way of executing recursion statements?