746c70c95b
- Updated column name handling in `row_to_json` to use lowercase for ODBC databases. - Added `canonical_col_name` function to standardize column names. - Modified SQL queries in tests to use lowercase column names for consistency. - Enhanced tests for edge cases and variations in column naming.
11 lines
171 B
SQL
11 lines
171 B
SQL
select
|
|
'csv' as component,
|
|
';' as separator;
|
|
|
|
select
|
|
0 as id,
|
|
'Hello World !' as msg
|
|
union all
|
|
select
|
|
1 as id,
|
|
'Tu gères '';'' et ''"'' ?' as msg; |