Ideas for the sql command

[Ole Tange]

The DBURL is not strictly defined yet, and I need some input on what
would be a good behaviour.

What should the following commands do to cause the least surprise for the user:

# 1. Should this run 'select * from foo' on the sqlite base /tmp/file.sqlite
sql 'sqlite:////tmp/file.sqlite?select * from foo;'

# 2. Should this run 'select * from foo' on the sqlite base /tmp/file.sqlite
sql 'sqlite:////tmp/file.sqlite?select%20*%20from%20foo;'

# 3. What should this do
sql 'sqlite:////tmp/file.sqlite?select%20*%20from foo;'

# 4. What should this do
sql "sqlite:////tmp/file.sqlite?select * from foo where url like 'bar%';"

# 5. What should this do
sql "sqlite:////tmp/file.sqlite?select * from foo where url like 'bar%20';"

# 6. Should this return "Incomplete SQL: select * from foo"
# Or should it add the missing ;
sql sqlite:////tmp/file.sqlite 'select * from foo'


/Ole