Preserve MultiLine SQL

[ati-ozgur]

When I use ElSqlBundle to read external sql file. An multiline SQL changed to one line sql. For example:

@name(example) SELECT
COUNT(*) FROM Employee

this is changed to SELECT COUNT(*) FROM Employee

I would like to preserve multi line structure of SQL if it is possible.

[jodastephen]

I'm sure it is possible. The question is why is it necessary?

[ati-ozgur]

If sql file content is preserved with multi lines, Database developer more easily re-use this files. I would like to copy paste sql from Sql Client (Toad, Sql Server Management Studio) to elsql file. Also copy paste from elsql to this sql clients. Right now : ElSql does not preserve multi lines therefore comments in sql does not work. Consider this example.

SELECT 
* FROM
EMPLOYEES  
WHERE
( -- only active employees
Status = 1
)

this sql is changed to following and gives sql error.

SELECT * FROM EMPLOYEES WHERE ( -- only active employees Status = 1)

I would like to use my sql scripts with least amount of modification.

[jodastephen]

I fixed the trailing comment issue, but this one is surprisingly hard to fix as it has knock on effects all over the place,