using select to join on json data

[steverweber]

I assume this will require a virtual table but I think it's worth asking about because JSON might be a growing use case of interest.

CREATE TABLE IF NOT EXISTS taa (
    id text UNIQUE NOT NULL,
    data jsonb
);
CREATE TABLE IF NOT EXISTS tbb (
    id text UNIQUE NOT NULL,
    data jsonb
);
INSERT INTO tbb (id, data) VALUES ('22', '{"stuff":"woot"}');
INSERT INTO taa (id, data) VALUES ('1', '{"taa_fk":"22"}');

a user is trying to join using the URL grammar; I'm stuck. Is something like this possible without using a virtual table?

curl 'localhost/?select=*,tbb!inner(data->>taa_fk=id)'

thanks!

[steve-chavez]

You would need a computed relationship for this.

[steverweber]

thanks.