Comment on Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filtersComments−akavi11yMost of your favorite languages have sql composition libraries that'll get you 90% of this (Arel for Ruby, SqlAlchemy for Python, etc, etc).The remainder, the "piping" syntax, is pretty easy to implement (Takes about 30-40 lines of ruby on top of Arel, speaking from experience).So then, is this just a matter of wrapping a library in a web page and calling it SAAS? Or am I just totally missing the point?−senthadevOP11yPiping is used to merge the tables rows. Tables can be merged in multiple ways, for example by join, left join, exists, not exists, union, minus etc.. And you can have the pipe chain up to 255 levels.
Comments
Most of your favorite languages have sql composition libraries that'll get you 90% of this (Arel for Ruby, SqlAlchemy for Python, etc, etc).
The remainder, the "piping" syntax, is pretty easy to implement (Takes about 30-40 lines of ruby on top of Arel, speaking from experience).
So then, is this just a matter of wrapping a library in a web page and calling it SAAS? Or am I just totally missing the point?
Piping is used to merge the tables rows. Tables can be merged in multiple ways, for example by join, left join, exists, not exists, union, minus etc.. And you can have the pipe chain up to 255 levels.