是否有人用思源实现了生词本？

直接制卡试试？

1. 将块引新建文档路径设置到某个父文档下
2. 遇到生词时按 Alt+[ 快捷键新建文档或引用已有的生词文档
3. 所有新建的生词文档就都集中在你设置的某个父文档下
4. 在父文档中使用目录插件插入子文档块引

当前页单词

WITH subpages AS (
    SELECT id, content, path
    FROM blocks
    WHERE type = 'd' AND path LIKE '%/.block{.root_id}/______________-_______.sy'
)
SELECT 
    '[' || s.content || '](siyuan://blocks/' || s.id || ')' AS __1____pre__单词,
    (SELECT b1.content 
     FROM blocks b1 
     WHERE b1.root_id = s.id 
       AND b1.type = 'p' 
       AND b1.parent_id = (SELECT id FROM blocks WHERE root_id = s.id AND type = 'h' AND content = '汉义' AND subtype = 'h3')
     LIMIT 1) AS __2____pre__汉义
FROM subpages s
ORDER BY s.path
LIMIT 100

主要功能是通过 sql 查询挂件来实现的，相关的 sql 如下，因为我这个是韩语的生词本，所以针对韩语词尾变形作了优化，英语、其它语言的话，相应修改就行。

单词本

WITH RECURSIVE
  hanyi_blocks(id, parent_id, root_id, content, type, subtype, level) AS (
    SELECT id, parent_id, root_id, content, type, subtype, 0
    FROM blocks
    WHERE type = 'h' AND content = '汉义' AND subtype = 'h3'
  
    UNION ALL
  
    SELECT b.id, b.parent_id, b.root_id, b.content, b.type, b.subtype, hb.level + 1
    FROM blocks b
    JOIN hanyi_blocks hb ON b.parent_id = hb.id
    WHERE hb.level < 5  -- 限制递归深度，防止查询过大
  ),
  ciyuan_blocks(id, parent_id, root_id, content, type, subtype, level) AS (
    SELECT id, parent_id, root_id, content, type, subtype, 0
    FROM blocks
    WHERE type = 'h' AND content = '词源' AND subtype = 'h3'
  
    UNION ALL
  
    SELECT b.id, b.parent_id, b.root_id, b.content, b.type, b.subtype, hb.level + 1
    FROM blocks b
    JOIN ciyuan_blocks hb ON b.parent_id = hb.id
    WHERE hb.level < 5  -- 限制递归深度，防止查询过大
  )
SELECT
    '[' || b.content || '](siyuan://blocks/' || b.id || ')' AS __1____pre__单词,
    (
        SELECT GROUP_CONCAT(cb.content, '
')
        FROM hanyi_blocks cb
        WHERE cb.root_id = b.id AND cb.type = 'p'  -- 只选择段落类型的块
        ORDER BY cb.id
    ) AS __2____pre__汉义,
    (
        SELECT GROUP_CONCAT(cb.content, '
')
        FROM ciyuan_blocks cb
        WHERE cb.root_id = b.id AND cb.type = 'p'  -- 只选择段落类型的块
        ORDER BY cb.id
    ) AS __3____pre__词源,
    b.created AS __4____date__创建日期
FROM
    blocks AS b
WHERE
    b.type = 'd'
    AND b.content REGEXP '^[\x{AC00}-\x{D7AF}\s]+$'  -- 筛选文档标题为纯韩语字符（允许空格）
    AND EXISTS (
        SELECT 1
        FROM blocks hb
        WHERE hb.parent_id = b.id AND hb.type = 'h' AND hb.subtype = 'h3' AND hb.content = '汉义'
    )
ORDER BY
    b.created DESC
LIMIT 1000

例句

WITH RECURSIVE
current_document AS (
    SELECT 
        content AS title,
        CASE 
            WHEN content LIKE '%다' THEN substr(content, 1, length(content) - 1)
            ELSE content
        END AS root
    FROM blocks
    WHERE id = '.root{.id}'  -- 获取当前文档的ID
),
vowel_changes(from_vowel, to_vowel) AS (
    SELECT '이', '여' UNION ALL
    SELECT '으', '어' UNION ALL
    SELECT '아', '어' UNION ALL
    SELECT '오', '와' UNION ALL
    SELECT '우', '워' UNION ALL
    SELECT '이', '에' UNION ALL
    SELECT '지', '져' UNION ALL
    SELECT '치', '쳐' UNION ALL
    SELECT '비', '벼' UNION ALL
    SELECT '피', '펴' UNION ALL
    SELECT '기', '겨' UNION ALL
    SELECT '키', '켜' UNION ALL
    SELECT '시', '셔' UNION ALL
    SELECT '디', '뎌' UNION ALL
    SELECT '티', '텨' UNION ALL
    SELECT '히', '혀' UNION ALL
    SELECT '미', '며' UNION ALL
    SELECT '니', '녀' UNION ALL
    SELECT '리', '려'
),
possible_changes(original, changed, level) AS (
    SELECT root, root, 0
    FROM current_document
  
    UNION ALL
  
    SELECT 
        pc.original,
        substr(pc.changed, 1, instr(pc.changed, vc.from_vowel) - 1) || 
        vc.to_vowel || 
        substr(pc.changed, instr(pc.changed, vc.from_vowel) + length(vc.from_vowel)),
        pc.level + 1
    FROM possible_changes pc
    JOIN vowel_changes vc
    WHERE pc.changed LIKE '%' || vc.from_vowel || '%'
    AND pc.level < 2  -- 限制递归深度
)
SELECT DISTINCT
    '[' || replace(b.content, pc.changed, '==' || pc.changed || '==') || '](siyuan://blocks/' || b.id || ')' AS __1____pre__例句,
	b.hpath AS __2__文档路径,
    cd.title AS __3__搜索词,
    pc.changed AS __4__匹配形式
FROM
    blocks AS b,
    current_document cd,
    possible_changes pc
WHERE
    b.type = 'p'
    AND b.hpath LIKE '%韩语%'
    AND (
        b.content LIKE '%' || pc.changed || '%'
        OR b.content LIKE '%' || pc.changed || '다%'
        OR b.content LIKE '%' || pc.changed || '어%'
        OR b.content LIKE '%' || pc.changed || '아%'
        OR b.content LIKE '%' || pc.changed || '여%'
        OR b.content LIKE '%' || pc.changed || '야%'
    )
    AND b.root_id != '.root{.id}'  -- 排除当前文档
GROUP BY b.id
ORDER BY
    b.path
LIMIT 30