Join condition

Wappler General Need Help
1

Is it possible to define joint condition other than inner, right and left?
Like full outer join or outer join?

2

Use the Custom Query

3

Thanks.
One more question
the “like” doesn’t work like “Contain” in the normal query.
I have the expression {{$_Get.Input_String}}.
I want to filter my table starting with the first character.
Now I ned the whole expression for filtering