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
1d7fc802-4fdf-4f9c-8995-523e9803ddc5

null
79
1d7fc802-4fdf-4f9c-8995-523e9803ddc5

null
80
1d7fc802-4fdf-4f9c-8995-523e9803ddc5

null
81
1d7fc802-4fdf-4f9c-8995-523e9803ddc5

null
82
1d7fc802-4fdf-4f9c-8995-523e9803ddc5

null
83
1d7fc802-4fdf-4f9c-8995-523e9803ddc5

null
84
1d7fc802-4fdf-4f9c-8995-523e9803ddc5


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
df9a493f-a91f-47f3-8330-3a7c6ada9df3

null
79
4d4fa28d-49cd-42eb-9578-cd70b1ebdf41

null
80
cd209a56-3a6e-4e69-b136-f3ad9fe59a5a

null
81
9dca3b8e-0965-4188-9250-59148ad03542

null
82
2c301ee8-58cb-45c9-84d9-7f16e3332635

null
83
ee54c4f6-94be-4cca-b4fb-06bf293e866b

null
84
f593d972-7c2b-45b0-8348-8b812a7e1c2b

id	externalId	GUID
null	78	1d7fc802-4fdf-4f9c-8995-523e9803ddc5
null	79	1d7fc802-4fdf-4f9c-8995-523e9803ddc5
null	80	1d7fc802-4fdf-4f9c-8995-523e9803ddc5
null	81	1d7fc802-4fdf-4f9c-8995-523e9803ddc5
null	82	1d7fc802-4fdf-4f9c-8995-523e9803ddc5
null	83	1d7fc802-4fdf-4f9c-8995-523e9803ddc5
null	84	1d7fc802-4fdf-4f9c-8995-523e9803ddc5

id	externalId	GUID
null	78	df9a493f-a91f-47f3-8330-3a7c6ada9df3
null	79	4d4fa28d-49cd-42eb-9578-cd70b1ebdf41
null	80	cd209a56-3a6e-4e69-b136-f3ad9fe59a5a
null	81	9dca3b8e-0965-4188-9250-59148ad03542
null	82	2c301ee8-58cb-45c9-84d9-7f16e3332635
null	83	ee54c4f6-94be-4cca-b4fb-06bf293e866b
null	84	f593d972-7c2b-45b0-8348-8b812a7e1c2b