SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Details (
    TourCompletionDateTime VARCHAR NOT NULL,
    TourID                 VARCHAR NOT NULL,
    PRIMARY KEY (TourID)
);
✓
INSERT INTO Details (TourCompletionDateTime, TourID)
SELECT '2022-07-26T09:36:00.730589Z', 'tour541'
WHERE EXISTS (
        SELECT 1
        FROM Details
        WHERE TourCompletionDateTime < '2022-07-26T09:36:00.730589Z'
      )
   OR NOT EXISTS (SELECT * FROM Details);
✓
SELECT * FROM Details;


TourCompletionDateTime
TourID


2022-07-26T09:36:00.730589Z
tour541