Method insertQuery

src/pg.ts:353–369

(
        table: SqlTable,
        set: SqlSetValueMap,
        returning?: SqlResultColumnSelector | undefined,
    )

    }

    insertQuery(
        table: SqlTable,
        set: SqlSetValueMap,
        returning?: SqlResultColumnSelector | undefined,
    ): ExecutableSqlQuery {
        let i: [number] = [1]
        let line = `INSERT INTO "${table.name}"`
        line += ` (${Object.keys(set).join(", ")})`
        line += ` VALUES (${Object.keys(set).map(() => "$" + (i[0]++)).join(", ")})`
        if (typeof returning != "undefined") {
            line += ` RETURNING ${this.createSelectQuery(returning)}`
        }
        return [
            line,
            ...Object.values(set)
        ]
    }

    updateQuery(
        table: SqlTable,