如何根据布尔值将SQL行拆分成多行？

SELECT 
    CASE 
        WHEN bool_column = true THEN 'row1'
        WHEN bool_column = false THEN 'row2'
    END AS row_identifier,
    other_columns
FROM 
    your_table;

SELECT 
    column1,
    column2,
    ...
FROM 
    your_table
WHERE 
    row_identifier = 'row1'

UNION

SELECT 
    column1,
    column2,
    ...
FROM 
    your_table
WHERE 
    row_identifier = 'row2';