Add support for advanced SQL features and improvements

[jgaleotti]

### Summary

This pull request introduces support for a range of advanced SQL features and general heuristic improvements. The updates ensure better handling and support for complex SQL structures, making the SQL processing logic more robust and comprehensive.

### Changelog

- **Multischema Handling**: Utilized `nullSafeEndsWithIgnoreCase` to retrieve `DataRow` values.
- **SQL Heuristics Improvements**:
  - Added handling for parenthesized select items.
  - Introduced support for Common Table Expressions (CTEs), including alias resolution.
  - Enhanced detection of tables and columns in DELETE statements with subqueries.
  - Improved evaluation of `ORDER BY` expressions.
  - Specific logic added for `SELECT` queries with `LIMIT` clauses.
- **New SQL Function Support**:
  - Added support for functions: `LOWER()`, `NOW()`, `DATE_TRUNC()`, and `COALESCE()`.
  - Enhancements for `TIME()` function.