You certainly would not want that? E.g. queries for google.com, discourse.pi-hole.net, www.mozilla.org all resolve to the same 1.2.3.4 IP?
I'm going to instead assume that you want Pi-hole to identify a requesting client by its name rather than by its IPv6.
Note that in contrast to IPv4's single address, a client always has multiple IPv6 addresses per interface from different ranges with different scopes and purposes by default (the most common ranges being fe80::/10
(link-local ), fd00::/8
(ULA) and 2000::/3
(GUA)).
With DHCP, a client may register a hostname during DHCP lease negotiation, and a router's DHCP server may or may not inject the respective DNS records into that router's DNS server.
While Stateful DHCPv6 would allow a client to supply a Client FQDN, the majority of IPv6 clients would not use Stateful DHCPv6 at all.
Instead, they construct their IPv6 addresses autonomously by combining an IPv6 prefix (procured from your router via Stateless DHCPv6 or RAs) with an interface identifier computed by the device itself using SLAAC.
Pi-hole can make an effort to try to associate the same hostname it knows for an IPv4 address to an IPv6 that originates from the same MAC, but that approach has its limits, as it is obviously bound to same link devices and affected by randomised MAC addresses and L3 routing equipment.
Furthermore, public GUA addresses are publically resolvable, i.e. your ISP would be authoritative for providing names (and often does so, by supplying generic names somehow encoding the IPv6 address).
And temporary IPv6 addresses are even intended to make it harder to identify a device, by regularly changing at least an IPv6 address's interface identifier portion - it would be counterproductive to assign a unique hostname to those that would allow identification.
To be able to identify clients by name in Pi-hole's dashboard, there are probably three different approaches:
a. encourage clients to use their link-local address when talking to Pi-hole
by changing their IPv6 prefix policies accordingly (requiring respective changes on each device)
b.configure your router to propagate your Pi-hole machine's link-local IPv6 along with its IPv4 as local DNS server
c. configure your router to propagate exclusively your Pi-hole machine's IPv4 address for DNS
While a. and b. should result in clients using a stable LLA or ULA IPv6 for their DNS requests, you'd still have to procure and maintain names for those IPv6 addresses.
In contrast, c. would have clients send their DNS requests via IPv4 exclusively, i.e. you would not see any IPv6 client addresses in Pi-hole's Query Log anymore. And as IPv4 addresses are usually easily associated with hostnames, this would be my personal recommendation.
Pi-hole would still happily answer any allowed request for an AAAA record with a set of IPv6 addresses, so dual-stack clients would retain their full IPv6 resolution capabilities.
You'd have to consult your router's documentation and support in order to verify whether your router would support that.
In any case, as long as your router is advertising its own IPv6 address as DNS server, any device may by-pass Pi-hole via IPv6.
It's crucial to find a way to configure your router to advertise no IPv6 DNS address at all, or at least propagate your Pi-hole host machine's ULA (or LLA) IPv6 as sole DNS server.