neuralib.sqlp.stat_start.update

neuralib.sqlp.stat_start.update(table, *args, **kwargs)

UPDATE: https://www.sqlite.org/lang_update.html

>>> update(A, A.a==1).where(A.b==2).build() 
UPDATE A SET A.a = 1 WHERE A.b = 2

features supporting

• UPDATE [OR …]

• SET COLUMN = EXPR

• FROM

• WHERE

• ON CONFLICT (COLUMNS) SET (COLUMNS) = EXPR

• returning clause

features not supporting

• WITH [RECURSIVE]

• (qualified table name) INDEXED BY

• (qualified table name) NOT INDEXED

Parameters:

• table (type[T])

• args (bool | SqlCompareOper)

• kwargs

Returns:

Return type:

SqlUpdateStat[T]