Proper way to construct a multi tenant database system using sqlite?

[Sourabhpatel1]

I am trying to design a system where there is a master database which contains the records of companies the user creates and other information related to that particular company and for each company a user creates I want to create a new sqlite file named abc_ltd.db, xyz_ltd.db e.t.c.
What is the best approach to tackle this problem. I am thinking of having a function that retrieves the database url at runtime and feeds it to the pool creation logic like so

pub struct AppState {
    pub master_db: Pool<Sqlite>,
    pub current_company_db: Option<Pool<Sqlite>>,
}

impl AppState {
     pub async fn new(db_path: &str) -> Result<Self, Error> {
        let options = SqliteConnectOptions::new()
            .filename(db_path)
            .create_if_missing(true);
        let pool = SqlitePool::connect_with(options).await?;
        Ok(AppState{master_db: pool, current_company_db: None})
    }
   pub async fn set_current_company_db(id: i32) -> Result<Self, Error> {
      //query the master database for current company database url with id
      //create a new pool
      //set the AppState.current_company_db to that pool
   }
}

would this approach work and what are performance implications for this appraoch.