You can add Ubuntu PPAs and install software from them on Debian. Occasionally, the software won't run because it's expecting different versions of its dependencies, but I'd say this is the exception rather than the rule. It's more likely to be an issue with games or specialised scientific tools, whereas development tools probably won't be fussy about which versions they require. And you can always use Ubuntu inside a container (with Podman or Docker), chroot or virtual machine (libvirt or VirtualBox), or even use an alternative package manager like Nix, Spack or Guix on top of Debian!

One final suggestion is to simply look to see if Debian already has a piece of software when people suggest using a PPA. Some developers don't like Debian (for instance because Debian disables tracking code by default) and recommend PPAs when you don't actually need them.

P.S. 'PPA' is a Ubuntu term, while Debian tends refer to 'third-party repositories' instead. Luckily, they are exactly the same thing!