mssqldef: Error when parsing UPDATE statement with FROM caluse.

[odz]

Platform

• OS: Linux
• RDBMS: SQL Server
• Version: 0.16.7

Current Schema

CREATE TABLE reservation (
  id BIGINT NOT NULL IDENTITY (1, 1),
  start_time DATETIME2(0) NOT NULL,
  end_time DATETIME2(0) NOT NULL,
  reserve_time INTEGER,
  CONSTRAINT reservation_pk PRIMARY KEY CLUSTERED (id)
);
GO

CREATE TRIGGER reservation_insert ON reservation
INSTEAD OF UPDATE
AS
SET NOCOUNT ON
UPDATE reservation
SET
  start_time = inserted.start_time,
  end_time = inserted.end_time,
  reserve_time = DATEDIFF(second, inserted.start_time, inserted.end_time)
FROM inserted
WHERE reservation.id = inserted.id
GO

Current output (--export)

2023/09/17 02:23:13 found syntax error when parsing DDL "CREATE TRIGGER reservation_insert ON reservation
INSTEAD OF UPDATE
AS
SET NOCOUNT ON
UPDATE reservation
SET
  start_time = inserted.start_time,
  end_time = inserted.end_time,
  reserve_time = DATEDIFF(second, inserted.start_time, inserted.end_time)
FROM inserted
WHERE reservation.id = inserted.id
": syntax error at position 255 near 'from'

Expected output (--export)

CREATE TABLE reservation (
  id BIGINT NOT NULL IDENTITY (1, 1),
  start_time DATETIME2(0) NOT NULL,
  end_time DATETIME2(0) NOT NULL,
  reserve_time INTEGER,
  CONSTRAINT reservation_pk PRIMARY KEY CLUSTERED (id)
);
GO

CREATE TRIGGER reservation_insert ON reservation
INSTEAD OF UPDATE
AS
SET NOCOUNT ON
UPDATE reservation
SET
  start_time = inserted.start_time,
  end_time = inserted.end_time,
  reserve_time = DATEDIFF(second, inserted.start_time, inserted.end_time)
FROM inserted
WHERE reservation.id = inserted.id
GO