Planetary Development
Planetary Development
No, currently there are no plans. But you can do it yourself very easily if you like to add it like the notnull implementation. Everything happens in the [$colum helper](https://github.com/planetarydev/json-sql-builder2/tree/master/sql/helpers/ddl/column).
@lukesrw some news on that?
You are right. There is no plugin-system, because I would have all changes done by the community should end up in a pull request. So feel free to fork this...
There should be no problem writing the new modify-helper class. For Inline-SQL use the Helper "__" [https://github.com/planetarydev/json-sql-builder2/tree/master/sql/helpers/misc/__](https://github.com/planetarydev/json-sql-builder2/tree/master/sql/helpers/misc/__).
I would suggest some usage like this: ```javascript sql.$update({ $table: "ball", $setXML: { cmdList: { $modifyXML: { __: "insert 1030 into (/cmdList)[1]" } } }, $where: { ballId: 1234 }...
Sorry for my late answer. I wrote this lib because i worked with MeteorJS and Try to change the mongo DB to postgres with livequeries.
Have a look at the from clause helper which already supports subqueries. [https://github.com/planetarydev/json-sql-builder2/tree/master/sql/helpers/queries/from](https://github.com/planetarydev/json-sql-builder2/tree/master/sql/helpers/queries/from) ```javascript function() { return sql.build({ $select: { $from: { people: 'p', skills: { $select: { $from: 'people_skills'...
It is done by the select operator... [https://github.com/planetarydev/json-sql-builder2/blob/master/sql/operators/select/select.js#L82](https://github.com/planetarydev/json-sql-builder2/blob/master/sql/operators/select/select.js#L82)
Currently Not supported. But it will be an easy Job. You can Do it like the examples in the docs. Every PR with new Operatorsand helpers are welcome. If you...