Option to create aliases

[Vasdranna]

Hi!
I think not, but... is there a way to create aliases? Something like alias cls = system clear or alias sf $1 = select * from $1?

Or at least an option to use favorite queries without the need to type \f? I know this might be a silly thing to ask, but I think the app would benefit from having the ability to create and use custom aliases.

Thanks for such a useful tool, by the way!

[amjith]

You can already use placeholders in favorite queries. Such as

database> \fs simple1 SELECT * FROM users WHERE id = $1
database> \f simple1 42

That will substitute $1 with the number 42.

But this still requires you to have the prefix \f in order to invoke it. There is not alias feature since that makes it hard to differentiate between a regular SQL statement or an alias. For instance, a user could create an alias called update and point it to SELECT 1 that would confuse mycli since there is no great way to figure out if the user meant to call the alias or a sql update statement.

Hence the prefix \f to invoke favorites.