No option for built-in functions on Insert about squel HOT 8 CLOSED

# (INSERT INTO) ... field ... value
class InsertFieldValueBlock extends squel.cls.InsertFieldValueBlock
    constructor: (options) ->
        super options
        @outputs = []
        @sqlFields = []
        @sqlValues = []

    # add fields to the output clause
    output: (fields) -> @outputs.push "INSERTED.#{f}" for f in fields

    # Update the given field with the given value.
    # This will override any previously set value for the given field.
    setSQL: (field, value) ->
        throw new Error "Cannot call set or setSQL or setFields on multiple rows of fields."  if @sqlValues.length > 1 or @values.length > 1

        # Explicity overwrite existing fields
        index = @sqlFields.indexOf(@_sanitizeField(field))
        if index isnt -1
            @sqlValues[0][index] = value
        else
            @sqlFields.push @_sanitizeField(field)
            index = @sqlFields.length - 1

            # The first value added needs to create the array of values for the row
            if Array.isArray(@sqlValues[0])
                @sqlValues[0][index] = value
            else
                @sqlValues.push [value]
        @

    buildStr: (queryBuilder) ->
        if 0 >= @fields.length and 0 >= @sqlFields.length  then throw new Error "set() needs to be called"

        vals = []
        for i in [0...@values.length]
            for j in [0...@values[i].length]
                formattedValue = @_formatValue(@values[i][j])
                if 'string' is typeof vals[i]
                    vals[i] += ', ' + formattedValue          
                else 
                    vals[i] = '' + formattedValue
        for i in [0...@sqlValues.length]
            for j in [0...@sqlValues[i].length]
                if 'string' is typeof vals[i]
                    vals[i] += ', ' + @sqlValues[i][j]          
                else 
                    vals[i] = '' + @sqlValues[i][j]

        "(#{@fields.concat(@sqlFields).join(', ')}) #{if @outputs.length isnt 0 then ("OUTPUT #{@outputs.join ', '} ") else ''}VALUES (#{vals.join('), (')})"

origInsert = squel.insert
squel.insert = -> origInsert options, [
    new squel.cls.StringBlock(options, 'INSERT'),
    new squel.cls.IntoTableBlock(options),
    new InsertFieldValueBlock(options)
]

squel.insert()
    .into "tasks"
        .output ["id","orderid"]
        .setSQL "orderid", "((#{squel.select()
            .field "COUNT(*)", "count"
            .from "tasks"
            .where "ticketid = ?", 24}) + 1)"
        .setSQL "createdat", "GETDATE()"