This is a Pipes Pro feature

In this guide, we have collected reference information on SQL support, commands, queries, and so on.

Pipes uses virtual SQL, a special dialect for sources and databases, so when you are using Pipes, you can use the same SQL dialect for all databases. Pipes will translate it internally using the correct syntax.