How about Favorite queries `Positional Parameters` add Default values support

[yurenchen000]

Favorite queries support shell-style parameter substitution. Save your favorite query with parameters as placeholders (e.g. $1, $2, $3, etc.):

Maybe looks like

\fs user_by_name select * from users where name = '${1:-john}'

\f user_by_name
call without args use the default value john

[yurenchen000]

use case maybe:

/fs list_user select * from users where $1 order by id ${2:-desc} limit ${3:-10}

## call with
/f list_user 'name like "john%"'  asc 5
/f list_user 'name like "john%"'  asc
/f list_user 'name like "john%"' 

/fs list_user2 select * from users where $1 order by id desc $2

## call with
/f list_user2 'name like "john%"'  'limit 5'
/f list_user2 'name like "john%"' 

arg can be omitted instead of error missing substitution for $2 in query

[rolandwalker]

Hi! What happens if the user specifies a default value for $1 but not $2?

[yurenchen000]

Hi! What happens if the user specifies a default value for $1 but not $2?

I think this is worth discussing and deliberation

• If following shell behavior, arg without explicit default values got empty value
  //Just run with warning

• or Abort with error
  //Maybe rigorous enough
  //or let user explicit declare default values

[rolandwalker]

I would prefer to abort with error in that case.

But, would default values work better if the parameters were named rather than positional? Probably yes!

[yurenchen000]

named parameters

good idea!

[rolandwalker]

Pending solution in #2085 .

On the downside, Jinja2 is more verbose than the original proposal. On the upside, it is more powerful and covers more cases.

[rolandwalker]

Released in https://github.com/dbcli/mycli/releases/tag/v2.10.0 .