Template:Spell table

This template generates a table filled with spells that satisfy the provided condition. It requires some knowledge of SQL to operate.

Example:

{{Spell table
|where=damage_type = "fire"
}}

Name	Level		Cast time	Duration	Range/Area	Attack/Save	Damage/Effect
[[File:{{{controller icon}}}|link=Alchemist's Fire (action)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				5 turns	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Blazing Retaliation|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				4 turns	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Burning Avarice|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Burning Hands|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	DEX save	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Burning Overflow|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				1 turn	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Chromatic Orb: Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Cinderous Swipe|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Death Burst (Fire)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Detonate|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Diabolic Chains|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	DEX save	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Embrace of the Inferno|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Erupting Cinder|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fiery Bolt|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fiery Regurgitation|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Bolt|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Breath (Cone)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Breath (Dragons)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Breath (Line)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Breath (Magma Mephit)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fireball|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Firebolt?|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Firewine Explosion|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Flame Strike|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Flames of the Phoenix|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Flaming Sphere|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Forever Indebted|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Glyph of Warding: Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Heat Metal|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				10 turns	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Heat Metal: Reapply Damage|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				10 turns	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellcrawler|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellfire Exhaust|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				1 turn	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellfire Missiles|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellfire Orb|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellflame Cleave|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				1 turn	{{{range}}}m / ft	DEX save	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellish Rebuke|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	DEX save	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Igniting Spark|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				2 turns	{{{range}}}m / ft	DEX save	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Immolating Gaze|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				3 turns	{{{range}}}m / ft	INT save	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Incinerate|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Incinerate (Incineration Caster)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Incineration Caster: Overheat|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Kith'raki Inferno|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Lorroakan's Firestorm|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Overheat|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				3 turns	{{{range}}}m / ft	CON save	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Produce Flame: Hurl|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Ram|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Ram (Hell Sphere)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Ravaging Inferno|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Rays of Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Rays of Fire (Cantrip)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Rolan's Firestorm|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Scorching Ray|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Self-Detonate|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Self-Detonate (Steel Watcher Titan)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Smouldering Touch|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				2 turns	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Sphere of Elemental Balance: Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	Attack roll	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Sweeping Cinder Strike|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Wall of Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}				-	{{{range}}}m / ft	-	Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}