Here on the forum you can find several examples of using the SQL command line client directly from Sesame using @RedirectProcess. If you use the forum's search function, remember to set it to search all posts, rather than just this week or month, etc.

Using the command line client for MySQL (both from an earlier post):

var aa as string

aa = @RedirectProcess("mysql --user=yourlogin --password=yourpassword", "show databases")
writeln(aa)
 

or

var aa as string
var sql as string

sql = "USE dbtest;"
+     "SELECT * FROM AUTHORS;"
+     "GO"

aa = @RedirectProcess("mysql --user=you --password=pwd", sql)
writeln(aa)
 

Depending on how your SQL system is configured, locally or remotely, using the command line interface may be quite a bit more efficient than going through a HTML interface.