Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version


PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit


create table a (
 id text
);

insert into a values 
('1234-campaign=main&content=video&keyword=man'),
('4321-campaign=cast&source=youtube');

create table b (
  row_id int,
  campaign text,
  content text,
  keyword text,
  source text,
  clicks int
);

insert into b values
(1234,'main','video','man','undefined',124),
(4321,'cast','undefined','undefined','youtube',10),
(5312,'cast','undefined','undefined','undefined',9999);
2 rows affected

3 rows affected

select *
  from b
       join a
         on to_jsonb(b)||jsonb_build_object('text_row_id', b.row_id::text)
              @> jsonb_object(
                             regexp_split_to_array(
                               'text_row_id-'||a.id, '[-&=]'
                             )
                           );


row_id
campaign
content
keyword
source
clicks
id


1234
main
video
man
undefined
124
1234-campaign=main&content=video&keyword=man

4321
cast
undefined
undefined
youtube
10
4321-campaign=cast&source=youtube

row_id	campaign	content	keyword	source	clicks	id
1234	main	video	man	undefined	124	1234-campaign=main&content=video&keyword=man
4321	cast	undefined	undefined	youtube	10	4321-campaign=cast&source=youtube