Save select statement for later

I'm often creating interesting SQL statements for my SQLite 开发者_如何学编程database.

Is it possible to save these statements for later use?

I'm looking for something more clever than copying to a text file.

Try something like:

CREATE VIEW my_view AS SELECT * FROM my_table;

Then you can re-use it later with:

SELECT * from my_view;

Not sure if this is what you're asking?