statamic / eloquent-driver

Provides support for storing your Statamic data in a database, rather than flat files.
https://statamic.dev/tips/storing-content-in-a-database
MIT License
108 stars 76 forks source link

force the column returns with table name as alias #53

Closed maxwkf closed 1 year ago

maxwkf commented 2 years ago

it helps to resolve the problem of same column name overrided by a joint table

jasonvarga commented 1 year ago

Sorry for the delay on this.

I'm more than happy to have this addressed, but joins are really only working by fluke because we proxy methods onto the eloquent builder. Joins aren't used anywhere else in Statamic yet.

Could you please provide a real use case for this, or more clearly explain the issue?

Also, please fix the merge conflicts.

Thanks!

maxwkf commented 1 year ago

Sorry for the delay on this.

I'm more than happy to have this addressed, but joins are really only working by fluke because we proxy methods onto the eloquent builder. Joins aren't used anywhere else in Statamic yet.

Could you please provide a real use case for this, or more clearly explain the issue?

Also, please fix the merge conflicts.

Thanks!

Sorry for the late reply.

I think the conversation started with Ryan from here https://discord.com/channels/489818810157891584/489819906540568593/1015191243183112212.

This conversation goes to a thread at last (https://discord.com/channels/489818810157891584/1015194102515638282).

As I need to create my own tag for searching entries which related to other collection entries, I need to create my custom search query.