Merging multiple SQL queries (useMultiSQL)

[joshmedeski]

I'd like to support calling multiple SQL databases and return the results together with one hook (see raycast/extensions#7665).

Can we create a useMultiSQL hook that accepts an array of paths to local SQL files and return the data, loading state and

  const { data, isLoading, permissionView } = useMultiSQL<HistoryEntry>([defaultHistory, profile1History, profile2History], getHistoryQuery(searchText));

Is this a good idea? I know there is a consideration on performance here and error handling if one of the DBs fails or returns data in an inconsistent format.