nulls in joined column when autopolars = True

[rwickramatunga]

What happens?

id	a
1	1
2	2
3	3

table_a

id	b
1	1
2	2

table_b

SELECT 
*
FROM table_1
LEFT JOIN table_2
ON table_1.id = table_2.id

Returns

id	a	b
1	1	1
2	2	2
null	3	null

When it should return

id	a	b
1	1	1
2	2	2
3	3	null

To Reproduce

import duckdb
%load_ext sql
%sql duckdb:///:memory:
%config SqlMagic.autopolars = True

%%sql
CREATE TABLE table_a (
    id INTEGER,
    a INTEGER
);

INSERT INTO table_a (id, a) VALUES
(1, 1),
(2, 2),
(3, 3);

CREATE TABLE table_b (
    id INTEGER,
    b INTEGER
);

INSERT INTO table_b (id, b) VALUES
(1, 1),
(2, 2);

%%sql
SELECT 
    *
FROM 
    table_a
LEFT JOIN 
    table_b
ON 
    table_a.id = table_b.id;

OS:

Debian GNU/Linux 11 (bullseye)

JupySQL Version:

0.10.16

Full Name:

Rajith Wickramatunga

Affiliation:

camh

[rwickramatunga]

While I'm aware this is a solution sometimes there's just too many columns which would make the wildcard and correct auto-resolution of name conflicts preferable

SELECT 
    table_a.id AS id,
    a,
    b
FROM 
    table_a
LEFT JOIN 
    table_b
ON 
    table_a.id = table_b.id;