Mushood Badulla

If you are running this in a command, change you storage.type config in config/forrest.php from session to cache ``` 'storage' => [ 'type' => 'cache', // Options include: 'session', 'cache',...

@staudenmeir Thank you for taking the time to review. I have applied lowercase for all the generated SQL. I have also added tests for exceptions and test for the function...

@staudenmeir I concur with your observation database | present | absent | priority | direction | result -- | -- | -- | -- | -- | -- mysql/mariadb |...

**Observation** I pondered on whether field was much better than case and by how much. In a table of 5000 records and a priority array of 1000, CASE executed in...

@taylorotwell I agree with sorting in php, if we are retrieving all the results. However, in some cases, it might be needed before retrieval such as providing a paginated list....

@bert-w I do agree that it can create horrible queries and if we are retrieving all results before ordering, I feel PHP ordering might have an edge. However, lets assume...

I have thought about this and my conclusion would be to use CASE even for mysql. This would provide a consistent output, independent of database driver, for cases where the...

I have applied the feedback of @rodrigopedra and @innocenzi in this PR #52535

@alirezadp10 since you are at the base of my PR #52535 , would love give you access to my fork. Otherwise, I don't mind making my changes to your fork...