
AIã«SQLãæžãããŠã倧äžå€«ãªäººãäŸé Œããæ¹ããã人
ãæžãããããšãšãæ£ããã倿ã§ãããããšã¯éã
AIã«SQLãæžãããããšã¯ãããé£ãããªãããå æã®å£²äžãåºããŠããšæç€ºããã°ããããããSQLãè¿ã£ãŠãããå®è¡ããã°æ°åãåºãã
ã ãããã®æ°åãæ£ãããã©ãããããªãã¯å€æã§ããã ãããã
SQLã¯æžãããšãããåºãŠããçµæãæ€èšŒããããšã®æ¹ãã¯ããã«é£ãããæ§æãšã©ãŒããªããã°äœãããã®æ°åã¯åºããåé¡ã¯ããã®æ°åãæå³éããã©ããã確èªããææ®µãæã£ãŠãããã©ããã ã
æ€èšŒã§ããªããŸãŸäœ¿ã£ãæ°åã§æææ±ºå®ãããã°ãééãã«æ°ã¥ãã®ã¯åŸã«ãªã£ãŠããã ããã®èšäºã§ã¯ããããã§ããªããªãAIã«SQLãæžãããããäŸé Œããæ¹ãããããšããå€æåºæºãå ·äœçã«æããŠããã
äœãåãããããèªåã®èšèã§æžãåºããã
AIã«SQLãæžãããåã«ããŸã確èªããŠã»ããããšããããæ¬²ããããŒã¿ã®æ¡ä»¶ãšåºåã®åœ¢ããèªåã®èšèã§æç« ã«ã§ããã ãããã
ã売äžåºããŠãã§ã¯ãªããã©ã®æéã®ãã©ã®ååã«ããŽãªã®ãã©ã®éèšåäœïŒæ¥å¥ãæå¥ãïŒã®ãäœãïŒéé¡ãä»¶æ°ãïŒåºãããã®ãã察象ã«è¿åããã£ã³ã»ã«ã¯å«ãã®ããè¡ãšåã¯äœãã©ã䞊ãã§ããã¹ããã
ãããèšèªåã§ããŠããªããšãAIã«æž¡ãæç€ºãææ§ã«ãªããAIã¯ææ§ãªæç€ºã«å¯ŸããŠãäœãããã®è§£éã§SQLãæžããåé¡ã¯ããã®è§£éãããªãã®æå³ãšäžèŽããŠãããã©ããããããªãèªèº«ã確èªã§ããªãããšã ãæå³ãæç¢ºã«ãªã£ãŠããªããã°ããåã£ãŠããããã®å€å®åºæºãããããååšããªãã
ãããã§ããŠããªããªãã以éã®è©±ã¯ãã¹ãŠæå³ããªãã
èªåã§ããŒã¿ã®äžèº«ã確èªã§ããã
ããŒãã«å®çŸ©ãã¡ã¿ããŒã¿ãæããŠããã£ããšããããããèªãã§ãå®éã®ããŒã¿ã®äžèº«ãèªåã§ç¢ºèªã§ããã ãããã
ããšãã°ã売äžããšããã«ã©ã ããã£ããšããŠããããçšèŸŒãªã®ãçšæãªã®ãããã£ã³ã»ã«æžã¿ã®æ³šæã¯å«ãŸããŠããã®ããå®çŸ©ãšããŠèããŠãããšããŠããå®ããŒã¿ãèŠãŠã確ãã«ãããªã£ãŠããããšç¢ºèªã§ããªããã°ãAIãæ£ããã«ã©ã ãéžãã ãã©ããå€å®ã§ããªãã
ãããŠã¡ã¿ããŒã¿ãæŽåãããŠããªãçŸå Žã®æ¹ãå€ãã®ãçŸå®ã ããã®ãšãã«ãèªåã§SELECTããŠå®ããŒã¿ãçºããŠãäœãå ¥ã£ãŠããã調ã¹ãããã ããããã«ã©ã ã®äžã« `["A","B","C"]` ã®ãããªJSONé åãå ¥ã£ãŠããããšããããèŠãããšããªããã°ãäœãå ¥ã£ãŠãããããããããªãã
ããŒã¿ã®é®®åºŠãåãåé¡ã ããã®ããŒãã«ã¯ãªã¢ã«ã¿ã€ã ã«æŽæ°ãããŠããã®ãããããšãæ¥æ¬¡ã®ãããåŠçã§åæ ãããŠããã®ããæšæ¥ã®å£²äžãåºããã€ããããããŒãã«ã®æŽæ°ã¯æ¯æ9æã§ããŸã äžæšæ¥ã®ããŒã¿ãŸã§ããå ¥ã£ãŠããªãã£ããããããæ å ±ã¯ããŒãã«ãèŠãã ãã§ã¯ããããªããç¥ããªããã°ãæ£ãããã©å€ããæ°åããã®ãŸãŸäœ¿ãããšã«ãªãã
AIã¯ããããããŒã¿ããããããæ±ããäžèº«ãèªåã§èªããªã人ã¯ãAIã®åŠçãæ£ãããã©ããå€å®ããææ®µãæã£ãŠããªãã
æå³ããæ¡ä»¶ã§çµã蟌ããŠããã
WHEREãLIKEã§æ¡ä»¶ãæå®ããã°ãããŒã¿ãçµã蟌ãããã ãããããæå³éãã®ããŒã¿ã ããåãåºããŠãããšã¯éããªãã
ããšãã°ãã»ããååã ãæœåºããŠããšAIã«æç€ºãããšãããAI㯠`WHERE product_name LIKE '%ã»ãã%'` ãšããSQLãæžãã ãããäžèŠæ£ãããã«èŠãããã ãå®è¡çµæãèŠããšãããªã»ãããã¿ã³ãããªãã»ããå°å·ãã©ã³ããªã©ããã»ããããšããæååãå«ãã ãã®ç¡é¢ä¿ãªååãæ··å ¥ããŠããã
æ¡ä»¶ãæžããããšãšããã®æ¡ä»¶ãæ¥åäžæ£ãããã©ããã¯å¥ã®åé¡ã ãAIã¯æç€ºãããéãã®æ¡ä»¶ãæžããããã®æ¡ä»¶ãæå³ãæ£ããåæ ããŠãããã¯ä¿èšŒããªããçµæãç®èŠã§ç¢ºèªããŠãããããªè¡ãæ··ãã£ãŠããªãããããã§ãã¯ããç¿æ £ããªããã°ããã®çš®ã®ãºã¬ã«ã¯æ°ã¥ããªãã
JOINã§è¡ãå¢ãã
2ã€ã®ããŒãã«ãJOINãããšãè¡æ°ãå¢ããããšãããã1人ã®é¡§å®¢ã«å¯ŸããŠæ³šæã3ä»¶ããã°ãJOINããçµæã¯3è¡ã«ãªãããã®ç¶æ ã§å£²äžãåèšãããšã顧客æ å ±ã3åã«ãŠã³ããããŠæ°åãèšããã
AIã¯æ§æãšããŠæ£ããJOINãæžãããšã©ãŒã¯åºãªããåºåãèŠãŠããè¡æ°ãå€ããå°ãªããã®å€æåºæºãæã£ãŠããªããã°ãèšåŒµã«æ°ã¥ããªããå æã®å£²äžãå®éã®2åã«ãªã£ãŠããŠããããããªãã®ããã§éããŠããŸããªã¹ã¯ãããã
ä»ã«ããããèŠãç®ã§ã¯æ°ã¥ããªãåé¡
ãããŸã§æãã以å€ã«ããSQLã®æåãç¥ããªããšæ°ã¥ããªãåé¡ã¯ããã€ãããã
NULLãæ··ãã£ãåãSUMãCOUNTã§éèšãããšãNULLã®è¡ã¯èšç®ããé€å€ããããããŒã¿ã100ä»¶ããã®ã«80ä»¶åããéèšãããŠããªãããšããããšãèµ·ãããããšã©ãŒã«ã¯ãªããªãã
GROUP BYã®ç²åºŠãéãã°ãåãã売äžéèšãã§ãæ°åã¯ãŸãã§å€ãããæ¥å¥ãšæå¥ããŠãŒã¶ãŒåäœãšæ³šæåäœãAIã¯äœãããã®ç²åºŠã§éèšãããããããããªãã®æå³éããã©ããã¯ããªãã«ããããããªãã
çµæã«éè€ãåºããšãã«DISTINCTãã€ããŠãçŽã£ãããšããã®ã¯ãçç¶ãæ¶ããã ãã ãéè€ã®åå ã¯JOINã®ä»æ¹ãããŒã¿èªäœã®å質ã«ããããDISTINCTã§èŠããªãããŠããŸããšåå ã«ãã©ãçããªãã
ããããæ§æãšã©ãŒã«ã¯ãªããªããçµæããããããšæ°ã¥ãããã«ã¯ãSQLãããŒã¿ãã©ãåŠçããŠããããçè§£ããŠããå¿ èŠãããã
çµæãæ£ããããèªåã§èª¿ã¹ãããã
ãããŸã§ã®è©±ããã¹ãŠã¯ãªã¢ãããšããŠããæåŸã«æ®ãåé¡ããããAIãæžããSQLãå®è¡ããŠãåºãŠããçµæãæ£ãããã©ããããããªãã¯èªåã§ç¢ºèªã§ããã ãããã
SQLã¯æ§æãæ£ãããã°åããåããçµæãäœãããã®æ°åãåºããã ããåããŠãããããšãšãæ£ãããããšã¯ãŸã£ããå¥ã ãAIãæžããã¯ãšãªã¯ãçµæãæ£ããããšãä¿èšŒããªãã
æ£ãããã©ããã調ã¹ãã«ã¯ãç¹å®ã®æ¡ä»¶ã§ãã¹ããäœãå¿ èŠããããããšãã°ããã®é¡§å®¢ã®ãã®æéã®æ³šæã ãã«çµã£ãŠãæã§èšç®ããçµæãšSQLã®åºåãäžèŽããããã確èªãããä»¶æ°ãåã£ãŠããããéé¡ãåã£ãŠããããæ³å®å€ã®è¡ãæ··å ¥ããŠããªããããããããã¹ããèªåã§èšèšããŠå®è¡ã§ããªããã°ãåºãŠããæ°åãä¿¡ããæ ¹æ ããªãã
ãããŠãã¹ããäœãããã«ã¯ãAIãæžããSQLãèªåã§èªãã§ãäœããã£ãŠãããçè§£ããå¿ èŠãããããã¹ãŠãçè§£ããå¿ èŠã¯ãªããããã¹ããè¡ãããã«ã¯ã©ã®éšåãã©ã®ããã«å€æŽããªããã°ãªããªãã®ã倿ã§ããªãã
ã€ãŸããSQLãæžãããããšã¯ã§ããŠãããã®SQLãèªãã§çè§£ããããšãã§ããªããã°ãæ€èšŒã®ææ®µãæã£ãŠããªãã®ãšåãã ã
äŸé Œããæ¹ãå šå¡ã®æéãç¡é§ã«ããªã
ãããŸã§èªãã§ãèªåã¯ãã¹ãŠç¢ºèªã§ãããšæã£ãæ¹ã¯ãã©ããAIãæŽ»çšããŠã»ããã
äžã€ã§ãäžå®ãããæ¹ã«ææ¡ããããæåããäŸé ŒããŠã»ããã
èªåã§SQLãæžããŠãçµæãããããããšã«åŸããæ°ã¥ãããããã¯èª°ãã«ææãããããã®æç¹ã§ãäœãèµ·ããããèªåã§èª¬æã§ããªããAIãæžããSQLãæã£ãŠãšã³ãžãã¢ã®ãšããã«è¡ãããšã³ãžãã¢ã¯ãŸããããªããäœããã£ãããã®è§£èªããå§ããããšã«ãªããæåããäŸé ŒãããŠããã°äžåºŠã§çµãã£ãä»äºããäºåŸã®è§£èªãšä¿®æ£ã§äœåãã®æéããããã
æžããŠããéäžã§ããã®ã«ã©ã äœã§ãããããã®æ¡ä»¶ã©ãæžãã°ããã§ããããšéœåºŠèãã«ããã±ãŒã¹ããããèªåã§æžããŠããã€ããã§ãå®éã«ã¯ãšã³ãžãã¢ã®æéã现åãã«æ¶è²»ããŠããã
ãäœãç¥ããããããæŽçããŠæž¡ãæ¹ããçµæçã«ããªãããšã³ãžãã¢ãéãããã£ãšèšãã°ãèªåãããèŠãæ°åããããªãããããBIã§èŠãããããã«ããŠãããã®ãæåã ãæ¯åSQLãæžãå¿ èŠããªããªãããããé£ããå 容ã§ããã°ãéœåºŠäŸé Œããããã¡ãã®æ¹ãå šå¡ã«ãšã£ãŠçç£çã ã
ãã®èšäºã§æããããšã¯ãããŒã¿ãå°éã«æ±ã人ãã¡ãæ¥åžžçã«ãã£ãŠããããšã®äžéšã ãå®çŸ©ã確èªããäžèº«ã調ã¹ãæ¡ä»¶ãæ€èšŒããçµæããã¹ãããããããã§ããããããä»äºãšããŠåŒãåããŠããããããŠããã§ãééãããã ãããããããã人å士ã§ã¬ãã¥ãŒãããŠããã