Laravel Eloquent Select Column as Alias

I like to use select statements to return specific columns. But I was happy to find out that you can alias your columns just like in sql. Which can be make things a breeze, depending on what you are doing. Remember to use the dot syntax to specify a table for joined columns with the … Read more

Laravel Case Insensitive Model Relationships

Normally, for case insensitive where queries, you can use the ‘ILIKE’ operator. But if you’re linking a prepopulated dataset, there’s a chance where a foreign key string doesn’t quite match another table’s key. There’s not too much info on getting case insensitive relationships working other than digging into the database dictionary and building your own … Read more