Yep, I’ve used that approach before on a couple of other projects.
You get faster comparisons, and more compact data - but interacting with the data in a CLI is a real PITA. 
(not like that’s a good reason not to do so, though)
As said previously, it’s trickier in LP, as the data types vary quite a bit in the other supported database implementations.