SQLite. Inverting the view schema.table

Question

PHP

I am working on Php MySQL. There was a desire to replace MySQL with SQLite for tests.
There are a lot of queries in the project where the schema is put down, for example SELECT * FROM `schema`.`table`
When building such a query in SQLite, I get the error "General error: 1 unknown database schema."
Is it possible somehow to create a multi-schema SQLite adapter?
If not, can you recommend an embeddable base supporting schemas

Answer 1

Attachable databases can be used instead of schemas.

attach database my.sqlite as myschema;
select * from myschema.t1;

PS I see that the question is already old, but perhaps the answer is useful to someone.