Changing '"' char by '`' in FunSQL and MySQL query

Specific Domains Data
1

I am testing FunSQL (is amazing!!!)
examples are in SQLite, ok, going to MySQL.

my simple query dont works, because of extras ‘"’ chars around field names. Ok, so made a function, that replace them, as:
function changeChar(s::String)
replace(s, ‘"’ => ‘`’)
end
and made it the last pipe in a query, like:

q = codigo |> Where(Get.ID_CODIGO .<= 100)
sql = render(q) |> String |> changeChar

and all is fine!

there is another way? like define the correct dialect as Mysql? something like that?
thanks!

2

You can specify the dialect when you render the query:

render(q, dialect = :mysql)
2 Likes