is there a way to give ATC a path to the sqlite database that depends on the OS of the node?

Check out the example of sending different configs to different platforms: https://github.com/kolide/fleet/blob/master/docs/cli/file-format.md#osquery-configuration-options