Something similar to this:
{
type: 'select',
table: 'mytable',
joins: [
{
target: 'mysecondtable',
type: 'inner',
on: { id: '$mytable.id$' },
columns: '*'
},
],
}
Which would result in
select "mytable".*, mysecondtable.* from "mytable" inner join "mysecondtable" on "mysecondtable"."id" = "id"."attribute_id"