Following the SQL provided in Db questions I’ve got the INSERT working on our test system, although I’m not sure if I need to be more careful with the sort_order value - and I’m avoiding populating the is_dependant and is_exclusive values at the moment e.g. SQL is only:
INSERT INTO sq_ast_lnk (linkid,majorid,minorid,link_type,value,sort_order,updated,updated_userid) VALUES (NEXTVAL('sq_ast_lnk_seq')...