私の投稿のタイミングが、もうちょっと早ければ良かったですね。総使用回数における有効成分を表示するかどうか、簡略形を使用するかどうかをユーザが選べるといろいろ使い勝手が良いと思うので、回数の方に総使用回数における有効成分を表示する方式に変更するにしても、このアイディアは残しておきたいところです。
ただ、とりあえず省略形でチェックして、最終的な資料にするときは正式形にするという使い方が多いと思うので、ツールバーに切替スイッチを置いて、再起動なしで切り替えられるのが望ましいですね。

tSeibun は下記のように正式形／省略形両方を持つように作っておいて、切換スイッチによって view を切り替えて再検索するってのはどうでしょう？

--/d
begin transaction;
drop table if exists tSeibun;
create temp table tSeibun as select distinct ippanmei, seibun, seibun as shoryaku 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]+';
commit;

総使用回数における有効成分非表示

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

総使用回数における有効成分表示(正式形)

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

総使用回数における有効成分表示(省略形)

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