引用：モード 4 をこれにした方が、より正確と言えそうですけどね。で、モード 5 はより短く「イミノクタジン(酢酸塩)」「イミノクタジン(アルシベル酸塩)」とか「メタラキシル」「メタラキシル(M)」という表記にするとか…。ちょっと考えてみます。一応、下記でいけると思います。新しいモード 5 は、正式な有効成分名と総使用回数で同一視すべき有効成分が簡潔に表現できるので、これをデフォルトにした方が良さそうです。
あるいは、モード 4-5 は現行のまま、モード 1 を新モード 5 にする手もありますね。この場合、モード 1 の選択肢は「標準(V)」のままで。でも、表示なしモードもあった方が良いかなあ…。

--/d
begin transaction;
drop table if exists tSeibun;
create temp table tSeibun as select distinct ippanmei, seibun, seibun as shoryaku, ippanmei as kanryaku from seibun where ippanmei != seibun;
update tSeibun set shoryaku = re_replace('.*及び([A-Z\-]+)(.*)', shoryaku, '(\1)\2') where shoryaku regexp '及び[A-Z]+';
update tSeibun set shoryaku = re_replace('.*及び(.*?)([A-Z\-]+)', shoryaku, '\1(\2)') where shoryaku regexp '及び.*?[A-Z]+';
update tSeibun set kanryaku = re_replace('^('||seibun||')(.*)', kanryaku, '\1(\2)') where kanryaku like seibun||'%';
update tSeibun set kanryaku = re_replace('(.*?)('||seibun||')$', kanryaku, '(\1)\2') where kanryaku like '%'||seibun;
update tSeibun set kanryaku = re_replace('(.+?)([A-Z\-]+.*)', kanryaku, '\1(\2)') where seibun like '%及び%' and kanryaku regexp '.+[A-Z]+.*$';
update tSeibun set kanryaku = re_replace('([A-Z\-]+)(.*)', kanryaku, '(\1)\2') where seibun like '%及び%' and kanryaku regexp '^[A-Z]+';
commit;

drop view if exists tvTsushoTekiyoSaku4;
CREATE temp VIEW tvTsushoTekiyoSaku4 AS SELECT DISTINCT 
sakumotsu, byochu, mokuteki, shurui, tsusho, jiki, baisu, ekiryo, hoho, basho, jikan, ondo, dojo, chitai, tekiyaku, kongo, kaisu,
concat('', seibun1, '('||(select seibun from tSeibun where ippanmei = seibun1)||')') as seibun1, keito1, kaisu1, mid1,
concat('', seibun2, '('||(select seibun from tSeibun where ippanmei = seibun2)||')') as seibun2, keito2, kaisu2, mid2,
concat('', seibun3, '('||(select seibun from tSeibun where ippanmei = seibun3)||')') as seibun3, keito3, kaisu3, mid3,
concat('', seibun4, '('||(select seibun from tSeibun where ippanmei = seibun4)||')') as seibun4, keito4, kaisu4, mid4,
concat('', seibun5, '('||(select seibun from tSeibun where ippanmei = seibun5)||')') as seibun5, keito5, kaisu5, mid5,
yoto, koka, zaikei
FROM ttTekiyoSaku;

drop view if exists tvTsushoTekiyoSaku5;
CREATE temp VIEW tvTsushoTekiyoSaku5 AS SELECT DISTINCT 
sakumotsu, byochu, mokuteki, shurui, tsusho, jiki, baisu, ekiryo, hoho, basho, jikan, ondo, dojo, chitai, tekiyaku, kongo, kaisu,
(ifnull((select kanryaku from tSeibun where ippanmei = seibun1),seibun1)) as seibun1, keito1, kaisu1, mid1,
(ifnull((select kanryaku from tSeibun where ippanmei = seibun2),seibun2)) as seibun2, keito2, kaisu2, mid2,
(ifnull((select kanryaku from tSeibun where ippanmei = seibun3),seibun3)) as seibun3, keito3, kaisu3, mid3,
(ifnull((select kanryaku from tSeibun where ippanmei = seibun4),seibun4)) as seibun4, keito4, kaisu4, mid4,
(ifnull((select kanryaku from tSeibun where ippanmei = seibun5),seibun5)) as seibun5, keito5, kaisu5, mid5,
yoto, koka, zaikei
FROM ttTekiyoSaku;