如何从字典中构造on语句

def construct_on_statement(dictionary):
    on_statement = ""
    for key, value in dictionary.items():
        table_a_field, table_b_field = key.split('.')
        on_statement += f"{table_a_field} = {table_b_field} AND "
    on_statement = on_statement[:-5]  # 去除最后的 " AND "
    return on_statement

# 示例字典数据
dictionary = {'A.id': 'B.id', 'A.name': 'B.name'}

# 生成on语句
on_statement = construct_on_statement(dictionary)

# 输出结果
print(on_statement)

ON A.id = B.id AND A.name = B.name