GORM Playground Link

go-gorm/playground#418

Description

• Tables with prefixes cannot specify query fields, so additional methods must be written. Wish that automatically generate corresponding fields according to the model.
• The association model specifies the association type, like Inner/right join, the example is automatically left join.
• Field conditions(where) can be set for prefixed association models.

Model: User/Company

-- mysql
select  `_prefixed_user`.name username,  `_prefixed_company`.name  from `_prefixed_user` inner join `_prefixed_company` on `_prefixed_user`.company_id=`_prefixed_company`.id
    where `_prefixed_company`.name like '%JC.inc%';