Executing raw SQL directly through the connection

[crimson-knight]

Executing raw SQL directly through the connection

[imdrasil]

Technically you always can get access to the adapter and execute whatever is supported by the driver - Jennifer::Adapter.default_adapter.exec. Also you can get access to a real connection going even further Jennifer::Adapter.default_adapter.db. I haven't tried this so can't say for sure - maybe this command can't be executed using prepared statement which is used by default. In this case the second me example should give you maximum flexibility crystal-db has right now

[crimson-knight]

I was able to get what I needed to work by using the command literal. The load from file commands do not work with prepared statements, so that was a challenge to figure out.

Would it be worth adding a method that allows easier access or documenting how to execute SQL statements directly? Something that goes right on the model and passes down to the Jennifer::Adapter.default_adapter.db or whichever adapter someone has configured for their connections.

[imdrasil]

What do you mean under "execute SQL statement directly"? To enforce unprepared statement instead of prepared for custom SQL query?

[crimson-knight]

Yes that's exactly what I mean

[imdrasil]

I will experiment with this