GpSQLBuilder just got support for Delete and Update statements.
GpSQLBuilder just got support for Delete and Update statements.
(Preemptive comment: I know half of you don't like this approach.)
https://github.com/gabr42/GpSQLBuilder
(Preemptive comment: I know half of you don't like this approach.)
https://github.com/gabr42/GpSQLBuilder
Just because some of us would never use it, doesn't mean that others won't find it useful. +1 for effort.
ReplyDeleteI like it :-)
ReplyDeleteInteresting indeed.
ReplyDeleteI like fluent. It is perfect for this kind of thing.
ReplyDeleteUpdated again:
ReplyDelete+ Following methods now accept `expression: IGpSQLBuilderExpression` parameter: IGpSQLBuilderCase.When, IGpSQLBuilder.&Case, IGpSQLBuilder.Having, IGpSQLBuilder.Where.
+ TGpSQLBuilderExpression.&Or can be used on an empty expression (it is silently converted to &And). This simplifies writing `for` loops which add conditions with &Or.
+ Added helper class SQL.
You can now write stuff like:
....Select.Column(SQL.Count(FieldName))...