insert with (key=value) not supported anymore?

[ingted]

It seems like syntax

insert into master:account (Username = 'admin', PasswordHash = '')

doesn't work with 0.17?

[ingted]

And

"insert into master:account (Username, PasswordHash)\r\nvalues('admin', '')"

works now

[NTDLS]

Good catch! Both are now implemented. Insert and update also now support function calls and formulas.

Example (ragged key/value pair):

insert into Test
(FirstName = 'Jane', LastName = 'Doe'),
(FirstName = 'John', MiddleName = Guid(), LastName = 'Doe')

Example (field list / value list):

insert into Test(FirstName, LastName)
values('Jane', 'Doe'),('John', 'Doe'),('Test', Guid())

update Test
set
	FirstName = 'Jane',
	MiddleName = Guid(),
	LastName = 'Doe'
where Id = 10