[feature] pipe support for insert

This is a **WIP** not ready to be merged.

Feature works but there is a problem when running tests, trying to figure out what's the problem in nixt.