SQLite 3.27

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

CREATE TABLE WorkHerdInventories(externalId INTEGER)
✓
INSERT INTO WorkHerdInventories(externalId) VALUES
(78), (79), (80), (81), (82), (83), (84);
✓
SELECT 
null as id,
whi.externalId,
(select lower(hex( randomblob(4)) || '-' || hex( randomblob(2))
         || '-' || '4' || substr( hex( randomblob(2)), 2) || '-'
         || substr('AB89', 1 + (abs(random()) % 4) , 1)  ||
         substr(hex(randomblob(2)), 2) || '-' || hex(randomblob(6)))) as GUID
FROM WorkHerdInventories as whi


id
externalId
GUID


null
78
654d1be1-5145-4559-b48d-f6cd1b6f1b2d

null
79
654d1be1-5145-4559-b48d-f6cd1b6f1b2d

null
80
654d1be1-5145-4559-b48d-f6cd1b6f1b2d

null
81
654d1be1-5145-4559-b48d-f6cd1b6f1b2d

null
82
654d1be1-5145-4559-b48d-f6cd1b6f1b2d

null
83
654d1be1-5145-4559-b48d-f6cd1b6f1b2d

null
84
654d1be1-5145-4559-b48d-f6cd1b6f1b2d


SELECT 
  null id,
  externalId,
  lower(
    hex(randomblob(4)) || '-' || hex(randomblob(2)) || '-' || '4' || 
    substr(hex( randomblob(2)), 2) || '-' || 
    substr('AB89', 1 + (abs(random()) % 4) , 1)  ||
    substr(hex(randomblob(2)), 2) || '-' || 
    hex(randomblob(6))
  ) GUID
FROM WorkHerdInventories


id
externalId
GUID


null
78
b96a41b3-a688-40ad-b776-a9e5097f4c84

null
79
6b8c1d47-7f23-4e5f-ad0e-9cf3b8aee93e

null
80
afdb1e69-2e2b-49fc-94d1-d52c44e64857

null
81
c5745161-3c54-47f9-9da2-194ec0b224bb

null
82
ea4c8f64-09fe-4b16-86d5-33a104dbc88b

null
83
fd3598db-0d09-471a-b28f-7a5d10f69031

null
84
8d2cd3d3-028e-4d20-9698-a4ddb0372a07

id	externalId	GUID
null	78	654d1be1-5145-4559-b48d-f6cd1b6f1b2d
null	79	654d1be1-5145-4559-b48d-f6cd1b6f1b2d
null	80	654d1be1-5145-4559-b48d-f6cd1b6f1b2d
null	81	654d1be1-5145-4559-b48d-f6cd1b6f1b2d
null	82	654d1be1-5145-4559-b48d-f6cd1b6f1b2d
null	83	654d1be1-5145-4559-b48d-f6cd1b6f1b2d
null	84	654d1be1-5145-4559-b48d-f6cd1b6f1b2d

id	externalId	GUID
null	78	b96a41b3-a688-40ad-b776-a9e5097f4c84
null	79	6b8c1d47-7f23-4e5f-ad0e-9cf3b8aee93e
null	80	afdb1e69-2e2b-49fc-94d1-d52c44e64857
null	81	c5745161-3c54-47f9-9da2-194ec0b224bb
null	82	ea4c8f64-09fe-4b16-86d5-33a104dbc88b
null	83	fd3598db-0d09-471a-b28f-7a5d10f69031
null	84	8d2cd3d3-028e-4d20-9698-a4ddb0372a07