Genie Discord forum

Once a backend is defined, is there a way to look into the actual SQL produced by the SearchLight API?

The query builder, any tutorials on that?

I understand I can do like: SearchLight.query("DESCRIBE <mytable>") But like before you run a migration for instance, is there a way to snoop into the generated SQL?

there is no option to "preview" an operation before you run it - but you can use the lower level API inside SearchLight. The general flow is

a) you set up your query objects b) these objects are converted to sql c) the resulting sql is run against the DB connection

you can see them in action in SearchLight.jl

but if you use the models interface, I never heard about generating incorrect queries - anything that could generate data loss for example

and the OOP API is pretty clear: only deleting an object will remove rows. And saving objects will insert or update.

a find operation will always be a pure SELECT

and for migrations, again, you have to write the down method and put the deletion of the table/columns/indices there - it won't delete anything by itself

Thank you Adrian, my use case was more in the interest of previewing the right datatypes, relations and composite keys for instance -sort of like dryrun. I'm not, at this point, worried about data loss 😅